Re: DISTINCT ... ORDER BY

From: Nabil Sayegh <nas(at)e-trolley(dot)de>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: Nabil Sayegh <postgresql(at)e-trolley(dot)de>, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: DISTINCT ... ORDER BY
Date: 2003-11-06 02:03:30
Message-ID: 3FA9ABF2.1040700@e-trolley.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Stephan Szabo wrote:

> You'd have to build a min(boolean) (which I'm sortof surprised isn't
> there) or use a case to convert it into an integer. Or given that it
> looks like you were doing DESC sorts, you'd probably want max().
> DISTINCT ON is a better choice for postgresql, it'll almost certainly be
> faster, but it's not very standard.

Thanks
I've choosen this way and it works like a charm.

cu
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2003-11-06 02:29:40 Re: DISTINCT ... ORDER BY
Previous Message Stephan Szabo 2003-11-05 22:55:06 Re: DISTINCT ... ORDER BY