From: Aasmund Midttun Godal <postgresql@envisity.com>
To: pgsql-sql@postgresql.org
Subject: Variables.
Date: Wed, 17 Oct 2001 01:00:54 GMT
Message-ID: <20011017010054.28016.qmail@ns.krot.org> (raw)
I would really like a feature :)
I do not know whether it is part of the SQL standard.
Variables...
e.g.
CREATE VARIABLE foobar INTEGER DEFAULT 1 NOT NULL;
SELECT * FROM thebar WHERE id = foobar;
CREATE TEMPORARY VARIABLE...
CREATE CONSTANT....
Basically all the functionality from the table columns (CHECK and REFERENCES...) and it must take any type, so that you can use user-created types as well.
SET foobar 3;
it could adopt properties from both runtime info and sequences...
My abilities in C, as in many other things is severely limited so I am asking someone else to do the dirtywork :). And I do appreciate that this may take some time.
It would be nice to have some sort of GRANT revoke SCHEME on it too...
I do acknowledge that this can be achieved with temporary and non temporary tables, but it can get ugly with these.
While I am at it I would highly suggest that there is some sort of SESSION_ID environment variable.
Some of the uses:
* Store things like personal preferences
* Parameters from a webserver
* Client application name
* etc.
Aasmund Midttun Godal
aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46
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: postgresql@envisity.com
Subject: Re: Variables.
In-Reply-To: <20011017010054.28016.qmail@ns.krot.org>
* 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