Paranthesis and Driver JDBC - Mailing list pgsql-general

From Albert
Subject Paranthesis and Driver JDBC
Date
Msg-id 1175083377.613412.220790@e65g2000hsc.googlegroups.com
Whole thread Raw
Responses Re: Paranthesis and Driver JDBC  (Thomas Burdairon <tburdairon@entelience.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Dmitry Koterov"
Date:
Subject: Re: Strange behaviour under heavy load
Next
From: Thomas Burdairon
Date:
Subject: Re: Paranthesis and Driver JDBC