ERROR: ORDER BY is not allowed in INSERT/SELECT

From: Loïc TREGOUËT <loic(at)cri74(dot)org>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: ERROR: ORDER BY is not allowed in INSERT/SELECT
Date: 2000-10-12 12:35:03
Message-ID: 39E5AFF7.6BB3E84F@cri74.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tomas Berndtsson 2000-10-12 12:35:13 grant to whole database
Previous Message Bruce Momjian 2000-10-12 03:02:13 Re: Char datatype