Hi,

our parser allows the into clause only between the target list and the
from clause. While this is surely the was I usually use that clause,
others dbms are different. Informix e.g. allows it also as the very last
clause after the having clause.

Is there a reason (standard?) why we don't allow that, or shall I go
ahead and commit a parser change to allow this order?

Michael
-- 
Michael Meskes
Email: Michael@Fam-Meskes.De
ICQ: 179140304
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!


Thu, 1 May 2003 18:53:43 +0200
Michael Meskes <meskes@postgresql.org>
select ... into question
Michael Meskes <meskes@postgresql.org> writes:
> our parser allows the into clause only between the target list and the
> from clause. While this is surely the was I usually use that clause,
> others dbms are different. Informix e.g. allows it also as the very last
> clause after the having clause.

> Is there a reason (standard?) why we don't allow that, or shall I go
> ahead and commit a parser change to allow this order?

SELECT INTO is so brain-damaged already that we should not enlarge the
scope of syntaxes it commandeers.  (People ought to be using CREATE
TABLE AS for this, IMHO.)

			regards, tom lane


Thu, 01 May 2003 13:32:11 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: select ... into question 