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

From Bruce Momjian
Subject Re: INSERT/SELECT with ORDER BY
Date
Msg-id 200010121900.PAA10883@candle.pha.pa.us
Whole thread Raw
In response to Re: INSERT/SELECT with ORDER BY  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-bugs
>
> 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.

Yes, added to TODO.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Truble with compilation
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Drop table doesn't drop serial sequences.