Postgres Pro
Downloads
Home   >   mailing lists

ERROR: ORDER BY is not allowed in INSERT/SELECT - Mailing list pgsql-admin

From Loïc TREGOUËT
Subject ERROR: ORDER BY is not allowed in INSERT/SELECT
Date
Msg-id 39E5AFF7.6BB3E84F@cri74.org
Whole thread Raw
In response to Re: ssh problem ?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: ERROR: ORDER BY is not allowed in INSERT/SELECT  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
Tree view 
    Hie,

Why the folowing is not accepted on PostgreSQL 7.0 but accepted on
PostgreSQL 6.5.3 ?

insert into tempo select id, name from topics order by name;
ERROR:  ORDER BY is not allowed in INSERT/SELECT


    Thanks

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Char datatype
Next
From: Tomas Berndtsson
Date:
Subject: grant to whole database