Re: select ... into question

Michael Meskes <meskes(at)postgresql(dot)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