Re: [SQL] DISTINCT not working - Mailing list pgsql-sql

From Brett W. McCoy
Subject Re: [SQL] DISTINCT not working
Date
Msg-id Pine.LNX.4.04.9906131337060.9557-100000@dragosani.lan2wan.com
Whole thread Raw
In response to DISTINCT not working  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
List pgsql-sql
> 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



pgsql-sql by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: DISTINCT not working
Next
From: Georg Ritter
Date:
Subject: backing up a db, jdbc, SQL syntax, etc...