More on unique vs distinct

Поиск
Список
Период
Сортировка
От Wm.A.Stafford
Тема More on unique vs distinct
Дата
Msg-id 45620FBB.2090403@marine.rutgers.edu
обсуждение исходный текст
Ответы Re: More on unique vs distinct  (Rodrigo Gonzalez <rjgonzale@gmail.com>)
Re: More on unique vs distinct  (Casey Duncan <casey@pandora.com>)
Re: More on unique vs distinct  (Michael Glaesemann <grzm@seespotcode.net>)
Список pgsql-general
I guess I should have been a bit more specific.  Here is an example of
the type of query I'm finding in the Oracle app and the results of my
attempt to find  a PostgreSQL equivalent.

select count(unique 'source_id') from obis_sources;
pgAdmin III query responds:
ERROR:  syntax error at or near "'source_id'" at character 23

select count(distinct 'source_id') from obis_sources;
pgAdmin III query responds:
ERROR:  could not identify an equality operator for type "unknown"

Thanks for all the help,
-=bill



В списке pgsql-general по дате отправления:

Предыдущее
От: Bricklen Anderson
Дата:
Сообщение: Re: PostgreSQL equivalent of the Oracale 'unique' qualifier
Следующее
От: Rodrigo Gonzalez
Дата:
Сообщение: Re: More on unique vs distinct