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

From Peter Eisentraut
Subject Re: ERROR: ORDER BY is not allowed in INSERT/SELECT
Date
Msg-id Pine.LNX.4.21.0010121658400.776-100000@peter.localdomain
Whole thread Raw
In response to ERROR: ORDER BY is not allowed in INSERT/SELECT  (Loïc TREGOUËT <loic@cri74.org>)
List pgsql-admin
Loïc TREGOUËT writes:

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

What's the point of this command?  The values in "tempo" are going to end
up in random order anyway.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-admin by date:

Previous
From: R D
Date:
Subject: control on table creation
Next
From: Bruce Momjian
Date:
Subject: Re: control on table creation