Function register_array_lower

src/functions/array_functions.rs:110–142

array_lower(array, dimension) - Get lower bound (always 1 for PostgreSQL arrays)

(conn: &Connection)

/// array_lower(array, dimension) - Get lower bound (always 1 for PostgreSQL arrays)
fn register_array_lower(conn: &Connection) -> Result<()> {
    conn.create_scalar_function(
        "array_lower",
        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 arr.is_empty() {
                        Ok(None)
                    } else if dimension == 1 {
                        Ok(Some(1))
                    } else if dimension == 2 {
                        // Check if it's actually a 2D array
                        if let Some(JsonValue::Array(_)) = arr.first() {
                            Ok(Some(1))
                        } else {
                            Ok(None)
                        }
                    } else {
                        Ok(None)
                    }
                }
                _ => Ok(None),
            }
        },
    )?;
    
    Ok(())
}

/// array_ndims(array) - Get number of dimensions
fn register_array_ndims(conn: &Connection) -> Result<()> {