So I just downloaded jyve and installed it. I am getting
SQL exceptions from the postgres driver (6.4).
Postgress dosn't allow left outer joins or use of the 'if' function
so the following query (there could be more) dosn't work:
select question.question_id, question.question_value, question.topic_id,
question.released,
sum(if((answer.deleted='N' AND (answer.released='Y' OR
answer.visitorid=-1)),1,0)) as answer_count
from question left join answer
on question.question_id = answer.question_id where question.topic_id in (6)
and question.deleted='N' AND ( question.released='Y' OR
question.visitorid=-1)
group by question.question_id, question.question_value, question.topic_id
order by question.topic_id,
Am I SOL ? Or does someone have the patch to implement this
as separate queries?
thanks
mike
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
