In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
says...
> SunWuKung <[EMAIL PROTECTED]> 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
>
SunWuKung <[EMAIL PROTECTED]> 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 y
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says...
> SunWuKung wrote:
>
> >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_optio
SunWuKung wrote:
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.
What you are trying t
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
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,
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
