From: Christoph Haller <ch@rodos.fzk.de>
To: pgsql-sql@postgresql.org
Cc: ajglist@izzy.net
Subject: Re: double linked list
Date: Thu, 30 Jan 2003 15:26:24 +0100
Message-ID: <3E393610.7E3B9E77@rodos.fzk.de> (raw)
>
> 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 = '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 neutral. 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 alternatives are?
>
plpgsql is the best I can think of.
And thanks for the quick reply.
Regards, Christoph
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: ch@rodos.fzk.de, ajglist@izzy.net
Subject: Re: double linked list
In-Reply-To: <3E393610.7E3B9E77@rodos.fzk.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