Re: [SQL] DISTINCT not working

> 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