Re: problem with distinct rows - Mailing list pgsql-general

From tony
Subject Re: problem with distinct rows
Date
Msg-id 1110289591.3566.39.camel@hush
Whole thread Raw
In response to Re: problem with distinct rows  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Le mardi 08 mars 2005 à 12:29 +0100, Martijn van Oosterhout a écrit :

> and, does it work? Obviously you need to put the joins in and such. But
> the outer query should be last, like:
>
> SELECT * FROM
>   (... subquery ...) AS x
> ORDER BY name;
>
> The outer query is only for ordering, the joins, etc should all be in
> the subquery...

You are my man!!!!!

Thanks for that

Beer =:-D

Tony


pgsql-general by date:

Previous
From: Howard Cole
Date:
Subject: Re: postgresql vs mysql performance comparison
Next
From: Lonni J Friedman
Date:
Subject: Re: RPM for whitebox linux - RH ES3 Clone