Re: [SQL] DISTINCT not working

Поиск
Список
Период
Сортировка
От Brett W. McCoy
Тема Re: [SQL] DISTINCT not working
Дата
Msg-id Pine.LNX.4.04.9906131337060.9557-100000@dragosani.lan2wan.com
обсуждение исходный текст
Ответ на DISTINCT not working  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
Список 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 по дате отправления:

Предыдущее
От: "Brett W. McCoy"
Дата:
Сообщение: DISTINCT not working
Следующее
От: Georg Ritter
Дата:
Сообщение: backing up a db, jdbc, SQL syntax, etc...