INSERT/SELECT with ORDER BY

============================================================================

POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Bob Rivoir
Your email address : rhr2(at)psu(dot)edu

System Configuration
---------------------
Architecture (example: Intel Pentium) : AMD Athlon

Operating System (example: Linux 2.0.26 ELF) : OpenLinux eDesktop 2.4

PostgreSQL version (example: PostgreSQL-7.0): PostgreSQL-7.0.2

Compiler used (example: gcc 2.8.0) : gcc egcs-1.1.2 release

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

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------