Re: 8.4.1 distinct query WITHOUT order by

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: 8.4.1 distinct query WITHOUT order by
Дата
Msg-id dcc563d10912220122y1d67ae2oa5f5b5c48f1319c1@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 8.4.1 distinct query WITHOUT order by  (msi77 <msi77@yandex.ru>)
Список pgsql-sql
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 по дате отправления:

Предыдущее
От: msi77
Дата:
Сообщение: Re: 8.4.1 distinct query WITHOUT order by
Следующее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: short-cutting if sum()>constant