Re: DISTINCT ON

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Jeremy Palmer <palmerj(at)xtra(dot)co(dot)nz>
Cc: pgsql-sql(at)postgresql(dot)org, 'Michael Glaesemann' <grzm(at)myrealbox(dot)com>
Subject: Re: DISTINCT ON
Date: 2005-11-19 14:31:20
Message-ID: 20051119143120.GA22669@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sat, Nov 19, 2005 at 17:06:27 +1300,
Jeremy Palmer <palmerj(at)xtra(dot)co(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andy Ballingall 2005-11-20 00:27:04 Is it possible to redirect an update/insert/delete to a different table?
Previous Message Nikolay Samokhvalov 2005-11-19 12:27:29 Re: Export to XML