Search Postgresql Archives

More on unique vs distinct

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux