- 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
- plpgsql_utility::define_function_args (public)
- plpgsql_utility::dollar (public)
- plpgsql_utility::generate_attribute_parameter_call (public)
- plpgsql_utility::generate_attribute_parameter_call_from_attributes (public)
- plpgsql_utility::generate_attribute_parameters (public)
- plpgsql_utility::generate_function_signature (public)
- plpgsql_utility::get_function_args (private)
- plpgsql_utility::table_column_type (public, deprecated)
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 (required)
- Author:
- Steve Woodcock <swoodcock@scholastic.co.uk>
- Created:
- 07/2001
- Partial Call Graph (max 5 caller/called nodes):
- 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):
- Testcases:
- No testcase defined.
plpgsql_utility::generate_attribute_parameter_call (public)
plpgsql_utility::generate_attribute_parameter_call \
[ -prepend prepend ] function_name pairsGenerates the arg list for a call to a pl/pgsql function
- Switches:
- -prepend (optional)
- Parameters:
- function_name (required)
- pairs (required)
- Author:
- Steve Woodcock <swoodcock@scholastic.co.uk>
- Created:
- 07/2001
- Partial Call Graph (max 5 caller/called nodes):
- 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_listWrapper for generate_attribute_parameter_call that formats default attribute list to the right format.
- Switches:
- -prepend (optional)
- Parameters:
- function_name (required)
- attr_list (required)
- Author:
- Michael Bryzek <mbryzek@arsdigita.com>
- Created:
- 11/2000
- Partial Call Graph (max 5 caller/called nodes):
- Testcases:
- No testcase defined.
plpgsql_utility::generate_attribute_parameters (public)
plpgsql_utility::generate_attribute_parameters [ -indent indent ] \
attr_listGenerates the arg list to a pl/sql function or procedure
- Switches:
- -indent (optional, defaults to
"4")- Parameters:
- attr_list (required)
- Author:
- Michael Bryzek <mbryzek@arsdigita.com>
- Created:
- 11/2000
- Partial Call Graph (max 5 caller/called nodes):
- 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 (required)
- Author:
- Steve Woodcock <swoodcock@scholastic.co.uk>
- Created:
- 07/2001
- Partial Call Graph (max 5 caller/called nodes):
- Testcases:
- No testcase defined.
plpgsql_utility::get_function_args (private)
plpgsql_utility::get_function_args function_name
uncached version returns list of lists args called from generate_attribute_parameter_call
- Parameters:
- function_name (required)
- Partial Call Graph (max 5 caller/called nodes):
- 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 (required)
- column (required)
- Author:
- Steve Woodcock <swoodcock@scholastic.co.uk>
- Created:
- 07/2001
- See Also:
- Partial Call Graph (max 5 caller/called nodes):
- Testcases:
- No testcase defined.
