From: Alan Gutierrez <ajglist@izzy.net>
To: Christoph Haller <ch@rodos.fzk.de>
To: pgsql-sql@postgresql.org
Subject: Re: double linked list
Date: Thu, 30 Jan 2003 08:30:33 -0600
Message-ID: <200301300830.33958.ajglist@izzy.net> (raw)
In-Reply-To: <3E392451.2DF44D6C@rodos.fzk.de>
References: <3E392451.2DF44D6C@rodos.fzk.de>
On Thursday 30 January 2003 07:10, Christoph Haller wrote:
> I've seen CELKO's reply and find it very useful.
> But I cannot find anything about
>
> > BEGIN ATOMIC
> > DECLARE rightmost_spread INTEGER;
> >
> > SET rightmost_spread
> > = (SELECT rgt
> > FROM Frammis
> > WHERE part = 'G');
> > ...
>
> Is this PostgreSQL at all? Any hints welcome.
Mr Haller
No, this is a dialect SQL-92 (SQL-99?) that Mr Celko uses for his
examples since his solutions are vendor nutral. He is big on standards,
so posting using the standard is his way of boosting them.
BEGIN ATOMIC is BEGIN in PG.
I am not sure how to declare a variable in PG in normal SQL. I don't do
it that often, but when I do I do this:
CREATE TEMPORARY TABLE Rightmost_Spread
AS SELECT rightmost_spread
FROM Frammis
WHERE part = 'G';
I wonder what the alterntatives are?
Alan Gutierrez - ajglist@izzy.net
http://khtml-win32.sourceforge.net/ - KHTML on Windows
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: ajglist@izzy.net, ch@rodos.fzk.de
Subject: Re: double linked list
In-Reply-To: <200301300830.33958.ajglist@izzy.net>
* 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