acs::db::postgresql method db_proc_opt_arg_spec (protected)

 <instance of acs::db::postgresql> db_proc_opt_arg_spec \
    [ -name name ] [ -type type ] [ -default default ]

Defined in packages/acs-tcl/tcl/acs-db-12-procs.tcl

Handling of default values: - $optional eq "N", default ignored, the attribute is required - default value different from NULL --> make it default - otherwise: non-required argument, bindvars e.g. empty it to null

Switches:

-name (optional)

-type (optional)

-default (optional)

Testcases:

No testcase defined.

Source code:

if {[string tolower $default] eq "null"} {
    set default_value ""
    set allowedEmptyOpt "-allow_empty"
} else {
    set default_value $default
    set allowedEmptyOpt ""
}
return [list [:dbproc_arg -name $name -type $type {*}$allowedEmptyOpt] $default_value]

XQL Not present:

Generic, PostgreSQL, Oracle