xo::db::DB-postgresql instproc list_of_lists (public)

 <instance of xo::db::DB-postgresql[i]> list_of_lists [ -dbn dbn ] \
    [ -bind bind ] [ -with_headers with_headers ] [ -prepare prepare ] \
    qn sql

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

Return each query result row as a list of column values.

Switches:
-dbn (optional)
Database name, or empty for the default.
-bind (optional)
Query bind values.
-with_headers (optional, defaults to "false")
Include a first list containing the column names.
-prepare (optional)
Optional prepared-statement argument types.
Parameters:
qn (required)
Query name.
sql (required)
SQL statement.

Testcases:
xotcl_core_tutorial_2, xotcl_core_tutorial_3
[ show source ]
Show another procedure: