Re: user defined variables

From: Moritz Sinn <moritz(at)freesources(dot)org>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: user defined variables
Date: 2002-05-24 15:21:12
Message-ID: m3bsb5tvvb.fsf@freesources.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Nigel J. Andrews" <nandrews(at)investsystems(dot)co(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joel Burton 2002-05-24 15:43:17 Re: user defined variables
Previous Message Joel Burton 2002-05-24 15:18:14 Re: Help with "empty()"