Does someone knows why this is not a supported feature?
I was happily SQL querying when I woke up from my dreams with this message:
ERROR: DISTINCT is not implemented for window functions
LINE 6: COUNT(DISTINCT handle) OVER (PARTITION BY pk_pessoas) AS ha...
It could be very useful to find unique references within groups of clone
records. Or there is another way to write this kind of query?
Example (reference is a column of record_data):
COUNT(DISTINCT reference) OVER (PARTITION BY group_key) AS unique_references
Daniel Cristian Cruz
クルズ クリスチアン ダニエル
pgsql-admin by date
|Next:||From: Daniel Cristian Cruz||Date: 2009-07-21 12:32:01|
|Subject: Re: COUNT(DISTINCT field) OVER (PARTITION BY another_field)|
|Previous:||From: Andreas Wenk||Date: 2009-07-21 10:38:31|
|Subject: Re: implement ldap authentication in PostgreSQL|