• Publicity: Public Only All

plpgsql-utility-procs.tcl

Procs to help generate pl/pgsql dynamically

Location:
packages/acs-subsite/tcl/plpgsql-utility-procs.tcl
Created:
Sun Jul 22 13:51:26 BST 2001
Author:
swoodcock@scholastic.co.uk
CVS Identification:
$Id: plpgsql-utility-procs.tcl,v 1.11.2.2 2021/02/17 08:20:57 gustafn Exp $

Procedures in this file

Detailed information

plpgsql_utility::define_function_args (public)

 plpgsql_utility::define_function_args attr_list

Returns the attribute list as a string suitable for a call to define_function_args.

Parameters:
attr_list
Author:
Steve Woodcock <swoodcock@scholastic.co.uk>
Created:
07/2001

Partial Call Graph (max 5 caller/called nodes):
%3

Testcases:
No testcase defined.

plpgsql_utility::dollar (public)

 plpgsql_utility::dollar

Return a literal dollar for use in .xql files.

Partial Call Graph (max 5 caller/called nodes):
%3

Testcases:
No testcase defined.

plpgsql_utility::generate_attribute_parameter_call (public)

 plpgsql_utility::generate_attribute_parameter_call \
    [ -prepend prepend ] function_name pairs

Generates the arg list for a call to a pl/pgsql function

Switches:
-prepend (optional)
Parameters:
function_name
pairs
Author:
Steve Woodcock <swoodcock@scholastic.co.uk>
Created:
07/2001

Partial Call Graph (max 5 caller/called nodes):
%3 package_instantiate_object package_instantiate_object (public) plpgsql_utility::generate_attribute_parameter_call plpgsql_utility::generate_attribute_parameter_call package_instantiate_object->plpgsql_utility::generate_attribute_parameter_call plpgsql_utility::generate_attribute_parameter_call_from_attributes plpgsql_utility::generate_attribute_parameter_call_from_attributes (public) plpgsql_utility::generate_attribute_parameter_call_from_attributes->plpgsql_utility::generate_attribute_parameter_call

Testcases:
No testcase defined.

plpgsql_utility::generate_attribute_parameter_call_from_attributes (public)

 plpgsql_utility::generate_attribute_parameter_call_from_attributes \
    [ -prepend prepend ] function_name attr_list

Wrapper for generate_attribute_parameter_call that formats default attribute list to the right format.

Switches:
-prepend (optional)
Parameters:
function_name
attr_list
Author:
Michael Bryzek <mbryzek@arsdigita.com>
Created:
11/2000

Partial Call Graph (max 5 caller/called nodes):
%3

Testcases:
No testcase defined.

plpgsql_utility::generate_attribute_parameters (public)

 plpgsql_utility::generate_attribute_parameters [ -indent indent ] \
    attr_list

Generates the arg list to a pl/sql function or procedure

Switches:
-indent (defaults to "4") (optional)
Parameters:
attr_list
Author:
Michael Bryzek <mbryzek@arsdigita.com>
Created:
11/2000

Partial Call Graph (max 5 caller/called nodes):
%3

Testcases:
No testcase defined.

plpgsql_utility::generate_function_signature (public)

 plpgsql_utility::generate_function_signature attr_list

Generates the signature for a pl/sql function or procedure

Parameters:
attr_list
Author:
Steve Woodcock <swoodcock@scholastic.co.uk>
Created:
07/2001

Partial Call Graph (max 5 caller/called nodes):
%3

Testcases:
No testcase defined.

plpgsql_utility::table_column_type (public, deprecated)

 plpgsql_utility::table_column_type table column
Deprecated. Invoking this procedure generates a warning.

Returns the datatype for column in table

Parameters:
table
column
Author:
Steve Woodcock <swoodcock@scholastic.co.uk>
Created:
07/2001

See Also:

Partial Call Graph (max 5 caller/called nodes):
%3

Testcases:
No testcase defined.
[ show source ]