> 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,... > ^
Notice: http://www.postgresql.org/docs/8.1/interactive/sql-select.html According to the syntax for a select a distinct | distinct on must be the first column specified in the syntax. So perhaps it is designed that way. Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster