No function escape processing?

From: "Jason Sando" <jsando(at)claritysys(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: No function escape processing?
Date: 2003-08-01 01:15:22
Message-ID: GOEJKBIJJHJANPJLFMDJIEGDCKAA.jsando@claritysys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Eric Tan 2003-08-01 01:20:43 Re: How to insert Chinese (big5) through JDBC?
Previous Message Kris Jurka 2003-07-31 20:07:08 Re: SSL support in PG 7.4