Thread: No function escape processing?

No function escape processing?

From
"Jason Sando"
Date:
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



Re: No function escape processing?

From
Barry Lind
Date:
Intentional in the sense that no one has stepped up to the plate to add
support for other functions.  Feel free to submit a patch.

thanks,
--Barry


Jason Sando wrote:
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>