Skip to main content

Module body_parameters

Module body_parameters 

Source
Expand description

The parameters a SQL routine’s body names, by name or by position, as PostgreSQL’s parser resolves them in each statement of the body.

Functions§

is_sql_body_parameter
Whether the body can name parameter: an input parameter. A procedure’s output parameter takes a placeholder in CALL but is not a parameter of its body.
record_sql_standard_body_parameters
Record in the statements of a SQL-standard body each name that resolves to a parameter, as the positional parameter it names, so that a later change to the relations the body reads cannot take the name: PostgreSQL stores the analyzed statements, in which a parameter reference stays a parameter. Returns whether a statement changed.
sql_body_parameter_names
The names a SQL body gives its input parameters, in order. A body given as a string names each by its own name; a SQL-standard body names the input at position n by the parameter declared at position n among all parameters, as interpret_AS_clause names them, so an input that follows an output parameter goes by that output parameter’s name.
sql_body_parameter_scope
The scope of the parameters a SQL body names, typed as params types them.
sql_body_parameters
The parameters a SQL body can name: the routine’s input parameters, which get_func_input_arg_names lists.