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

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

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

Return a list of ns_set handles, one per query result row.

Switches:
-dbn (optional)
Database name, or empty for the default.
-bind (optional)
Query bind values.
-prepare (optional)
Optional prepared-statement argument types.
Parameters:
qn (required)
Query name.
sql (required)
SQL statement.

Testcases:
xotcl_core_tutorial_2
Source code:
if {$sql eq ""} {set sql [:get_sql $qn]}
if {$bind ne ""} {set bindOpt [list -bind $bind]} {set bindOpt ""}

db_with_handle -dbn $dbn db {
  if {[info exists prepare]} {set sql [:prepare -handle $db -argtypes $prepare $sql]}
  set result [list]

  set answers [uplevel [list ns_pg_bind select $db {*}$bindOpt $sql]]
  while { [::db_getrow $db $answers] } {
    lappend result [ns_set copy $answers]
  }
  ns_set free $answers
}
return $result
XQL Not present:
Generic, PostgreSQL, Oracle
[ hide source ] | [ make this the default ]
Show another procedure: