xo::db::DB-postgresql instproc sets (public)
<instance of xo::db::DB-postgresql> 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 $resultXQL Not present: Generic, PostgreSQL, Oracle
![[i]](/resources/acs-subsite/ZoomIn16.gif)