Skip to main content

select_bound_sql

Function select_bound_sql 

Source
pub fn select_bound_sql(
    rel: &str,
    dim_cols: &[String],
    value_col: &str,
    agg: Option<&str>,
    vt: ValueType,
) -> Result<String>
Expand description

SELECT of a binding’s fact rows: dims as text…, then the value read as vt (float8, bool, text, or a datetime as int8 epoch milliseconds). With agg, one row per coordinate, its rows’ values aggregated (a bool’s min and max as bool_and and bool_or: SQL has no max(bool)). rel is a regclass::text, which Postgres has already quoted.