From: | Michael Loftis <mloftis(at)wgops(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Bug? Changing where distinct occurs produces error? |
Date: | 2006-07-07 21:52:01 |
Message-ID: | DE7D6281F4C40F472F6E0A6A@d216-220-25-20.dynip.modwest.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
OK I'm either insane or found a bug in 8.1.3
If you execute say:
SELECT DISTINCT(ua.user_id),pa.poll_id FROM user_answers ua, poll_answers
pa WHERE pa.poll_answer_id = ua.poll_answer_id AND ua.active='Y';
Everything is fine, however if you run
SELECT pa.poll_id,DISTINCT(ua.user_id) FROM user_answers ua, poll_answers
pa WHERE pa.poll_answer_id = ua.poll_answer_id AND ua.active='Y';
ERROR: syntax error at or near "DISTINCT" at character 19
LINE 1: SELECT pa.poll_id,DISTINCT(ua.user_id) FROM user_answers ua,...
^
Further if I wrap it in a SUM (with a group by pa.poll_id) I get no error.
I'm a little confused as to what is wrong with my second example there?
--
"Genius might be described as a supreme capacity for getting its possessors
into trouble of all kinds."
-- Samuel Butler
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2006-07-07 22:19:29 | Re: Bug? Changing where distinct occurs produces error? |
Previous Message | Stephane Bortzmeyer | 2006-07-07 20:58:41 | Re: How to optimize query that concatenates strings? |