Re: [ADMIN] ERROR: ORDER BY is not allowed in INSERT/SELECT

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 [EMAIL PROTECTED] http://y

[ADMIN] ERROR: ORDER BY is not allowed in INSERT/SELECT

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