Re: DISTINCT ... ORDER BY

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