Re: Is select a transaction starting statement?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>, 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 20:49:35
Message-ID: 200409142249.35367.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dennis Bjorklund wrote:
> 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.

It's the same in SQL 99. I think you missed that most of the "direct
SQL" is specified in part 5 instead of part 2. In SQL 2003 they have
merged these parts. The relevant section for you in SQL 99 is 4.6.3 in
part 5.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Passynkov, Vadim 2004-09-14 20:53:40 Re: NEW used in a query that is not in a rule
Previous Message Alexander Serkov 2004-09-14 19:12:46 Postgresql 8.0.0beta2 unicode problem