* Tom Lane (t...@sss.pgh.pa.us) wrote: > The reason it's sorting by all the columns is the DISTINCT
You might also verify that you actually need/*should* have the DISTINCT, if it's included today.. Often developers put that in without understanding why they're getting dups (which can often be due to missing pieces from the JOIN clause or misunderstanding of the database schema...). Stephen
signature.asc
Description: Digital signature