Re: Bug report (with solution) on org.postgresql.jdbc2.EscapedFunctions

On Wed, 5 Nov 2008, Christophe Janton wrote:

> org.postgresql.jdbc2.EscapedFunctions.constantToInterval method.
>
> Value parameter have not to contain an integer. For example : ? a prepared
> statment JDBC parameter
>
> each return of constantToInterval method like :
> *return "'"+value+" day'";*
> must be replaced by :
> *return "CAST(" + value + " || ' day' as interval)";*
>
> This modification required to remove the interval keyword of all method
> using constantToInterval.
>

I'm not sure I fully understand the problem.  Can you provide a testcase
to demonstrate the failure?

Kris Jurka