xo::db::postgresql instproc select (public)

 <instance of xo::db::postgresql[i]> select -vars vars  -from from  \
    [ -where where ] [ -groupby groupby ] [ -limit limit ] \
    [ -offset offset ] [ -start start ] [ -orderby orderby ] \
    [ -map_function_names map_function_names ]

Defined in /var/www/openacs/packages/xotcl-core/tcl/05-db-procs.tcl

Build a PostgreSQL SELECT statement from SQL fragments.

Switches:
-vars (required)
Expressions to select.
-from (required)
FROM clause contents.
-where (optional)
Optional WHERE condition.
-groupby (optional)
Optional grouping expressions.
-limit (optional)
Optional row limit.
-offset (optional)
Optional row offset.
-start (optional)
Compatibility option unused by PostgreSQL.
-orderby (optional)
Optional ordering expressions.
-map_function_names (optional, defaults to "false")
Compatibility option unused by PostgreSQL.

Testcases:
xotcl_core_tutorial_2
[ show source ]
Show another procedure: