Mikael Hedin <mikael(dot)hedin(at)irf(dot)se> writes:> SELECT COUNT (DISTINCT data ) FROM media;> ERROR: parser: parse error at or near "distinct"
This is supported since 7.0. I suspect you are running an old release.
regards, tom lane