Postgres Pro
Downloads
Home   >   mailing lists

Order by clause in 'select distinct'? - Mailing list pgsql-admin

From James Kelty
Subject Order by clause in 'select distinct'?
Date
Msg-id MDEDIKPCLCIKDGEMDJGMOEHECDAA.jamesk@ashlandagency.com
Whole thread Raw
Responses Re: Order by clause in 'select distinct'?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Optimizing a condition based on an a very unequally
Next
From: Peter Schuller
Date:
Subject: Postgres user lost its access