Postgres Pro
Downloads
Home   >   mailing lists

Re: DISTINCT ON - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: DISTINCT ON
Date
Msg-id 20051119143120.GA22669@wolff.to
Whole thread Raw
In response to Re: DISTINCT ON  ("Jeremy Palmer" <palmerj@xtra.co.nz>)
List pgsql-sql
Tree view 
On Sat, Nov 19, 2005 at 17:06:27 +1300, Jeremy Palmer <palmerj@xtra.co.nz> wrote:
> 
> Interesting enough, on my server the "distinct on" clause that I originally
> ran takes 10% of execution time that the query you provided does.

If DISTINCT ON wasn't useful, I doubt it would have been added.

pgsql-sql by date:

Previous
From: Nikolay Samokhvalov
Date:
Subject: Re: Export to XML
Next
From: Andy Ballingall
Date:
Subject: Is it possible to redirect an update/insert/delete to a different table?