I have a table in which I am storing parameters that I would like to use
as variables in a pgsql procedure.
Currently I find no other way to refer to these than to assign each
record to a variable by a separate query like this:
Declare
max_option integer;
Select Into max_option parameter_value From parameters Where methodid=
999 And parameter_name='max_option'
and so on for each parameter.
Is there a way to get all these parameters into one variable in pgsql -
eg. Select Into paramarray(param_name, param_value) parameter_name,
parameter_value Where methodid=999 - and refer to their values in a
simple way like param_array.max_option ?
Thanks for the help.
Balázs
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
