Hi,
We have a query that involves 'union' and 'except' clause. When it is run on the psql database at the backend it retuns the required data. However, when it is executed using the jdbc driver it is returning less number of records. The statements after the union and except clause are not getting executed. Is this a bug in the JDBC driver?
Also a similar problem is encountered in another query that uses 'case when <> then <> else <> end' the equivalent of 'decode'. This query returns records when exceuted at the backend, but when exceuted using the JDBC driver, it retuns no records. What could be the problem? Have any of you encountered a similar problem and how do we solve it?
Regards,
Gautham.