Re: Regression: Problems with Timestamp arguments

Поиск
Список
Период
Сортировка
От Lachezar Dobrev
Тема Re: Regression: Problems with Timestamp arguments
Дата
Msg-id CA+xsaB0ObYETZMAqwvWhXpVEsn1EVQ0rWuFCYcU3dTog95wstw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Regression: Problems with Timestamp arguments  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-jdbc
2013/9/10 Dave Cramer <pg@fastcrypt.com>:
> Protocol 2 just does textual replacement of the parameters and does not use
> prepared statements on the server.

  I see…
  That would also answer another question about why null arguments
fail with the current protocol, but don't with protocol 2 (Hibernate
uses Serializable -> bytea which can not be used in any way).

> There is no way to degrade only certain parts. Why is it not possible to
> cast this to timestamp ?

  That works:
   SELECT CAST(? AS TIMESTAMP) IS NULL;

  However this is something that would mandate rewriting hundreds of
queries in a working (with protocol version 2) product.

> Dave Cramer
>
> dave.cramer(at)credativ(dot)ca
> http://www.credativ.ca


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Regression: Problems with Timestamp arguments
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: 9.3 driver