In article <[EMAIL PROTECTED]>, dev@archonet.com says...
> 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.
> 
> 
This sounds very promising, but I have looked at the RECORD variable 
type, and found no example that would show how I could use it the way I 
described. 
In order to get the value of rec.max_option I would first need to 
dynamically create a record variable in which all the param_name values 
of the original recordset are columns and contain the corresponding 
param_value. I found no example how to do this - could you direct me to 
one?

Thanks.
Balázs

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to