pgsql variables from records - Mailing list pgsql-general

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