Thread: DISTINCT not working

DISTINCT not working

From
"Brett W. McCoy"
Date:

Re: [SQL] DISTINCT not working

From
"Brett W. McCoy"
Date:
> If I do a direct SQL statement to pull out the distinct values frm the 
> base table, it also returns a single row.  The values are there, as there 
> are over 100,000 rows in the table, and there should be about 6 distinct 
> values for the column in question.  I tried reindexing, vaccuming, and 
> everything, but cannot figure out why any statements selecting distinct 
> values on this table aren't working.

Never mind.  I got it working by restarting the postmaster.  I have no
idea what was causing the problem.

Brett W. McCoy                                                  http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
The Lord prefers common-looking people.  That is the reason that He makes
so many of them.    -- Abraham Lincoln