David Fetter <da...@fetter.org> writes: > SELECT count(DISTINCT i) OVER () FROM (VALUES (1),(2),(3),(1)) AS s(i); > ERROR: DISTINCT is not implemented for window functions
Which part of that message isn't clear to you? > Anyhow, I think it's a bug and needs back-patching. "Not implemented" is not a bug. Nice try though. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers