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