SunWuKung wrote:
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 ?
Have a look at using a variable of type RECORD. See the plpgsql
documentation for examples.
--
Richard Huxton
Archonet Ltd
