Re: Regression: Problems with Timestamp arguments

Hi,

On 11. sep. 2013, at 08:37, pgsql-jdbc-owner(at)postgresql(dot)org wrote:
> From: Lachezar Dobrev <l(dot)dobrev(at)gmail(dot)com>
> Subject: Re: Regression: Problems with Timestamp arguments
> Date: 10. september 2013 13:07:28 CEST
> To: Dave Cramer <pg(at)fastcrypt(dot)com>
> Cc: List <pgsql-jdbc(at)postgresql(dot)org>
>
>
> This works:
> PREPARE is_date_reached AS SELECT NOW() < $1 OR $1 IS NULL;
>
> However JDBC can not use the same parameter more than once…
> SELECT NOW() < ? OR ? IS NULL;
>
> Hmm. That's not good.

How about:
SELECT NOW() < ? OR $1 IS NULL;

I've at least always managed to use the same parameters over again like that in JDBC under normal circumstances, thought that's been with types the driver knew about.

Thanks, Thor Michael