acs::db::nsdb-postgresql method call acs_permission permission_p_recursive_array (public)

 <instance of acs::db::nsdb-postgresql> call acs_permission permission_p_recursive_array \
    [ -dbn dbn ] -objects objects  -party_id party_id  \
    -privilege privilege 

Defined in packages/acs-tcl/tcl/00-acs-tcl-init.tcl

Automatically generated method TYPES: {integer[]} integer {character varying}

Switches:

-dbn (optional)

-objects (required)

-party_id (required)

-privilege (required)

Testcases:

No testcase defined.

Source code:

set result {}; set start_time [expr {[clock clicks -microseconds]/1000.0}]
db_with_handle -dbn $dbn __DB {
   set s [ns_pg_bind select $__DB {select r.* from acs_permission__permission_p_recursive_array(:objects,CAST(:party_id AS integer),:privilege) as r}]
   while {[ns_db getrow $__DB $s]} {lappend result [ns_set values $s]}
}
ds_collect_db_call $dbn call "" "acs_permission__permission_p_recursive_array(:objects,CAST(:party_id AS integer),:privilege)" $start_time 0 ""
ns_set free $s
return $result

XQL Not present:

Generic, PostgreSQL, Oracle