Paranthesis and Driver JDBC

["Albert" <alberto.molteni@xxxxxxxxx>]

Hi all!

I use postgresql 8.0 and its driver for JDBC.A strange thing happens:
when my application creates a query it is created always with a
parenthesis more than expected, that is a query like this one:

SELECT * FROM table_x WHERE (table_x.afield='a' and
table_x.bfield='b')) order by table_x.a

This query is NOT executed using pgadmin, which detects the error, but
this does not happen in the application : the query isexecuted and the
correct resultis sent back by the database.

Is there some functionality in the driver that permits the correction
of this type of error? How could you explain this behaviour?

Thanks!


Alberto