Re: user defined variables - Mailing list pgsql-general

From Moritz Sinn
Subject Re: user defined variables
Date
Msg-id m3bsb5tvvb.fsf@freesources.org
Whole thread Raw
In response to Re: user defined variables  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Responses Re: user defined variables
List pgsql-general
"Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:

> On 24 May 2002, Moritz Sinn wrote:
> >
> > hi,
> >
> > isn't it possible to define own environment vars?
> >
>
> Did I miss something?
>
> I'd answer with:
>
>     Errrrr.......yeeeeees.
>
> Except I've got this distinct feeling I must have missed something.
>
> What is it you're trying to achieve other than setting environment variables
> which is shell specific?

well, i mean i want to make a value available under a certain name, for
the whole db session.
i want to do something like "UID=4545323667424;" and then be able to say
"SELECT * FROM USER WHERE uid=UID;"

But SET only accepts predefined environment variables.

thanks,

 moritz


--
#define FALSE   0               /* This is the naked Truth */
#define TRUE    1               /* and this is the Light */
    -- mailto.c

pgsql-general by date:

Previous
From: "Joel Burton"
Date:
Subject: Re: Help with "empty()"
Next
From: "Joel Burton"
Date:
Subject: Re: user defined variables