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