Re: INSERT/SELECT with ORDER BY - Mailing list pgsql-bugs

Stephan Szabo writes:
 >
 > Unless I'm horribly misreading the spec, this is correct.
 > ORDER BY is used in reference to cursor definitions and
 > direct select statements, but is not part of query expressions
 > which is what the INSERT INTO references.
 >
 >          <insert statement> ::=
 >               INSERT INTO <table name>
 >                 <insert columns and source>
 >
 >          <insert columns and source> ::=
 >                 [ <left paren> <insert column list> <right paren> ]
 >               <query expression>
 >               | DEFAULT VALUES
 >
 >          <insert column list> ::= <column name list>
 >
 > But, this may be a useful extension to allow, at least with the
 > existance of LIMIT.
 >
 > Stephan Szabo
 > sszabo@bigpanda.com
 >
 > On Thu, 17 Aug 2000, Bob Rivoir wrote:
 > >
 > > Please enter a FULL description of your problem:
 > > ------------------------------------------------
 > > I got the following error message when I tried to do an INSERT using
 > > SELECT ... ORDER BY:
 > >
 > > ERROR:  ORDER BY is not allowed in INSERT/SELECT


Is 7.1 able to do INSERT/SELECT with ORDER BY and LIMIT ?

Dirk