From: | Barry Lind <blind(at)xythos(dot)com> |
---|---|
To: | Jason Sando <jsando(at)claritysys(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: No function escape processing? |
Date: | 2003-08-06 23:57:02 |
Message-ID: | 3F3195CE.4040905@xythos.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Barry Lind | 2003-08-07 00:02:14 | Re: Server side resultset search (for performance reasons) |
Previous Message | Barry Lind | 2003-08-06 23:55:35 | Re: SSL support in PG 7.4 |