acs::db::nsdb-postgresql method call timespan join (public)
<instance of acs::db::nsdb-postgresql> call timespan join \ [ -dbn dbn ] -timespan_id timespan_id [ -start_date start_date ] \ [ -end_date end_date ]
Defined in packages/acs-tcl/tcl/00-acs-tcl-init.tcl
Automatically generated method TYPES: integer {timestamp with time zone} {timestamp with time zone}
- Switches:
- -dbn (optional)
- -timespan_id (required)
- -start_date (optional, accept empty)
- -end_date (optional, accept empty)
- Testcases:
- No testcase defined.
Source code: db_with_handle -dbn $dbn __DB { set s [ns_pg_bind 0or1row $__DB {select timespan__join(CAST(:timespan_id AS integer),:start_date,:end_date)}] return [ns_set value $s 0] }XQL Not present: Generic, PostgreSQL, Oracle