Re: problem with distinct rows

From: tony <tony(at)tgds(dot)net>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: Re: problem with distinct rows
Date: 2005-03-08 13:46:30
Message-ID: 1110289591.3566.39.camel@hush
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lonni J Friedman 2005-03-08 13:48:32 Re: RPM for whitebox linux - RH ES3 Clone
Previous Message Howard Cole 2005-03-08 13:20:57 Re: postgresql vs mysql performance comparison