Re: [HACKERS] VIEWS, DISTINCT and COUNT

Brian Hirt <bhirt@mobygames.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