Brian Hirt <bhirt(at)mobygames(dot)com> writes:
> "select count(distinct id) from table" is not supported.
Yup. It's on the TODO list:
* Allow COUNT(DISTINCT col)
> For both count(distinct) and distinct in views, I have this question: Is
> this something that needs to be supported but just never got implemented?
I'm not sure what Jan has in mind for views, but certainly
aggregate(DISTINCT ...) is an SQL-standard feature that we ought to
support. I don't think it's a simple addition though :-(
regards, tom lane