From: Christian Kratzer <ck@cksoft.de>
To: Jie Liang <jie@stbernard.com>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] \set
Date: Wed, 12 May 2004 12:13:24 +0200 (CEST)
Message-ID: <20040512120015.E61036@vesihiisi.cksoft.de> (raw)
In-Reply-To: <E7E213858379814A9AE48CA6754F5ECB36336D@mail01.stbernard.com>
References: <E7E213858379814A9AE48CA6754F5ECB36336D@mail01.stbernard.com>
Hi,
On Tue, 11 May 2004, Jie Liang wrote:
> Hi,
> How to use an internal variable?
> Original question was how to set a variable in postgresql?
> If I want to set a variable like start_date='2004-05-10';
> How could I use it in my SQL statement?
> E.g.
>
> Db> set start_date '2004-05-10'
> Db> select start_date as 'start date';
>
> It's not executable!
from doc/postgresql/html/sql-set.html
--snipp--
Synopsis
SET [ SESSION | LOCAL ] name { TO | = } { value | 'value' | DEFAULT }
SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT }
...
...
...
name
Name of a settable run-time parameter.
Available parameters are documented in Section 16.4 and below.
--snipp--
that is you can only use SET to change specific predefined parameters.
It does not say you could use SET to store other data local to the database
session.
As far as I know there are no session local variables in postgresql.
I could use something like this myself. The only workaround I know of
to have data local to a session is to create a temporary table for the data.
There are local variables in plpgsql if you are just looking for local
variables.
Greetings
Christian
--
Christian Kratzer ck@cksoft.de
CK Software GmbH http://www.cksoft.de/
Phone: +49 7452 889 135 Fax: +49 7452 889 136
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ck@cksoft.de, jie@stbernard.com, pgsql-admin@postgresql.org
Subject: Re: [SQL] \set
In-Reply-To: <20040512120015.E61036@vesihiisi.cksoft.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox