This seems like a simple SQL command, but I'm getting errors.
Running 6.5.0 under RedHat 5.2:
db=> select count(distinct customer_username) from customerdata;
ERROR: parser: parse error at or near "distinct"
How do you get a count of distinct data output via postgres? I can always
just count the number of tuples returned but this seemed to be a valid
query.
--------------------------------------------------------------------------
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email: aholtz(at)bright(dot)net
"It's not broken, it just lacks duct tape."
--------------------------------------------------------------------------