Обсуждение: select ... into question

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!

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