Re: 8.4.1 distinct query WITHOUT order by

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: msi77 <msi77(at)yandex(dot)ru>
Cc: Gary Chambers <gwchamb(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: 8.4.1 distinct query WITHOUT order by
Date: 2009-12-22 09:22:36
Message-ID: dcc563d10912220122y1d67ae2oa5f5b5c48f1319c1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Dec 22, 2009 at 12:11 AM, msi77 <msi77(at)yandex(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2009-12-22 12:35:27 short-cutting if sum()>constant
Previous Message msi77 2009-12-22 07:11:41 Re: 8.4.1 distinct query WITHOUT order by