Function register_array_upper

src/functions/array_functions.rs:77–107

array_upper(array, dimension) - Get upper bound of array dimension

(conn: &Connection)

/// array_upper(array, dimension) - Get upper bound of array dimension
fn register_array_upper(conn: &Connection) -> Result<()> {
    conn.create_scalar_function(
        "array_upper",
        2,
        FunctionFlags::SQLITE_UTF8 | FunctionFlags::SQLITE_DETERMINISTIC,
        |ctx| {
            let array_json: String = ctx.get(0)?;
            let dimension: i32 = ctx.get(1)?;
            
            match serde_json::from_str::<JsonValue>(&array_json) {
                Ok(JsonValue::Array(arr)) => {
                    if dimension == 1 {
                        Ok(Some(arr.len() as i32))
                    } else if dimension == 2 {
                        // For 2D arrays, check first element
                        if let Some(JsonValue::Array(inner)) = arr.first() {
                            Ok(Some(inner.len() as i32))
                        } else {
                            Ok(None)
                        }
                    } else {
                        Ok(None)
                    }
                }
                _ => Ok(None),
            }
        },
    )?;
    
    Ok(())
}

/// array_lower(array, dimension) - Get lower bound (always 1 for PostgreSQL arrays)
fn register_array_lower(conn: &Connection) -> Result<()> {