Content-Type: text/plain;
  charset="iso-8859-2"
From: Alan Gutierrez <ajglist@izzy.net>
Reply-To: ajglist@izzy.net
To: Christoph Haller <ch@rodos.fzk.de>, pgsql-sql@postgresql.org
Subject: Re: double linked list
Date: Thu, 30 Jan 2003 08:30:33 -0600
User-Agent: KMail/1.4.3
References: <3E392451.2DF44D6C@rodos.fzk.de>
In-Reply-To: <3E392451.2DF44D6C@rodos.fzk.de>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200301300830.33958.ajglist@izzy.net>

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
> >     =3D (SELECT rgt
> >          FROM Frammis
> >         WHERE part =3D '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 =3D 'G';

I wonder what the alterntatives are?

Alan Gutierrez - ajglist@izzy.net
http://khtml-win32.sourceforge.net/ - KHTML on Windows