xo::db::postgresql instproc select (public)
<instance of xo::db::postgresql> 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
![[i]](/resources/acs-subsite/ZoomIn16.gif)