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
