pgsql variables from records

SunWuKung <Balazs(dot)Klein(at)axelero(dot)hu> wrote:
>
> 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:

I'm not sure if you are talking about referenceing the individual
columns, or a set of rows.

For the first case

DECLARE
parameters tp_method1_params;

BEGIN
....

parameters := (SELECT param1, ...paramn) FROM paramtable;

SELECT method(param1, ...paramn);

END;

Or you could declare the method to accapt the record as its input
parameter.

For the second case, use an array. I just learned how to do that
on this list a couple of days ago.

DECLARE
paramarray tp_method_params[];

BEGIN
....

paramarray := ARRAY(SELECT ....);

END;

I hope this answers the question you were asking. {-;

-karl

> 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