Order by clause in 'select distinct'?

Поиск
Список
Период
Сортировка
От James Kelty
Тема Order by clause in 'select distinct'?
Дата
Msg-id MDEDIKPCLCIKDGEMDJGMOEHECDAA.jamesk@ashlandagency.com
обсуждение исходный текст
Ответы Re: Order by clause in 'select distinct'?
Список pgsql-admin
When I create a view by a query like the follow query:

SELECT DISTINCT ON (o.ordergenkey) o.ordergenkey, lip.payment FROM Ordr o,
LineItemPayment lip
WHERE o.ordergenkey = lip.orderfkey
and o.ordergenkey = ?

The view is created with an ORDER BY clause on the o.ordergenkey...

I think it might be an enforce rule for createing a view with a DISTINCT ON
phrase.

I would like to, if possible, get rid of the ORDER BY clause as it slow the
query to
a crawl.

Any ideas?

-James

James Kelty
Sr. Unix Systems Administrator
The Ashland Agency
541.488.0801
jamesk@ashlandagency.com


В списке pgsql-admin по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Optimizing a condition based on an a very unequally
Следующее
От: Peter Schuller
Дата:
Сообщение: Postgres user lost its access