[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] 8.4.1 distinct query WITHOUT order by
From:       Scott Marlowe <scott.marlowe () gmail ! com>
Date:       2009-12-22 9:22:36
Message-ID: dcc563d10912220122y1d67ae2oa5f5b5c48f1319c1 () mail ! gmail ! com
[Download RAW message or body]

On Tue, Dec 22, 2009 at 12:11 AM, msi77 <msi77@yandex.ru> wrote:
>> What are the ramifications of renaming the table (containing 8000
>> rows) and creating a view of the same name?
>
> View does not admit ORDER BY clause, at least, Standard does not.

Postgres certainly allows it, but I don't think it will help in this case.

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
[prev in list] [next in list] [prev in thread] [next in thread]