Re: INSERT/SELECT with ORDER BY

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(at)bigpanda(dot)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