Re: Is select a transaction starting statement?

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Is select a transaction starting statement?
Date: 2004-09-14 18:54:10
Message-ID: Pine.LNX.4.44.0409142052180.9559-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 14 Sep 2004, Alvaro Herrera wrote:

> -- The following SQL-data statements:
> [...]
> <direct select statement: multiple rows>.
> [...]
>
>
> The <direct select statement: multiple rows> is in time defined as
> <cursor specification>, which in turn is a <query expression>, which is
> our SELECT statement. A lot of jumps in the grammar, but it's there.

Nice.

In sql99 there is only <direct select statement: single row> which is
SELECT .. INTO .. But maybe some of the other includes queries after 4-5
jumps or so. Or maybe they simply forgot that one. Just my luck to be
reading sql99.

Thanks.

--
/Dennis Björklund

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Serkov 2004-09-14 19:12:46 Postgresql 8.0.0beta2 unicode problem
Previous Message Gaetano Mendola 2004-09-14 18:34:32 NEW used in a query that is not in a rule