Home > mailing lists

Re: 8.4.1 distinct query WITHOUT order by - Mailing list pgsql-sql

From	Scott Marlowe
Subject	Re: 8.4.1 distinct query WITHOUT order by
Date	December 22, 2009 08:22:46
Msg-id	dcc563d10912220122y1d67ae2oa5f5b5c48f1319c1@mail.gmail.com Whole thread Raw
In response to	Re: 8.4.1 distinct query WITHOUT order by (msi77 <msi77@yandex.ru>)
List	pgsql-sql

Tree view

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.

pgsql-sql by date:

From: msi77
Date: 22 December 2009, 06:19:46
Subject: Re: 8.4.1 distinct query WITHOUT order by

From: Ivan Sergio Borgonovo
Date: 22 December 2009, 11:35:45
Subject: short-cutting if sum()>constant

Re: 8.4.1 distinct query WITHOUT order by - Mailing list pgsql-sql

Previous

Next