acs::db::nsdb-postgresql method call instr (public)
<instance of acs::db::nsdb-postgresql> call instr [ -dbn dbn ] \ -str str -pat pat -dir dir -cnt cnt
Defined in packages/acs-tcl/tcl/00-acs-tcl-init.tcl
Automatically generated method TYPES: {character varying} character integer integer
- Switches:
- -dbn (optional)
- -str (required)
- -pat (required)
- -dir (required)
- -cnt (required)
- Testcases:
- No testcase defined.
Source code: db_with_handle -dbn $dbn __DB { set s [ns_pg_bind 0or1row $__DB {select instr(:str,:pat,CAST(:dir AS integer),CAST(:cnt AS integer))}] return [ns_set value $s 0] }XQL Not present: Generic, PostgreSQL, Oracle