No function escape processing? - Mailing list pgsql-jdbc

From Jason Sando
Subject No function escape processing?
Date
Msg-id GOEJKBIJJHJANPJLFMDJIEGDCKAA.jsando@claritysys.com
Whole thread Raw
Responses Re: No function escape processing?
List pgsql-jdbc
Is it intentional that the driver (7.3.4) doesn't do function escape
processing?

Eg:

  select * from mytable where {fn left(col_1, 1)} between 'A' and 'F'

results in:

    java.sql.SQLException: ERROR:  parser: parse error at or near "{"
      at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)

It looks like AbstractJdbc1Statement.replaceProcessing(String p_sql) only
escapes time/date literals and passes everything else directly through.

Thanks,

- Jason Sando



pgsql-jdbc by date:

Previous
From: Venkata Ramana
Date:
Subject: POSTGRE WESPHERE TECHNICAL DOUBT
Next
From: Eric Tan
Date:
Subject: Re: How to insert Chinese (big5) through JDBC?