acs::db::nsdb-postgresql method call instr (public)

 <instance of acs::db::nsdb-postgresql[i]> 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
[ hide source ] | [ make this the default ]
Show another procedure: