Something wrong with binding timestamp values

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Something wrong with binding timestamp values
Дата
Msg-id 200612061458.32156.peter_e@gmx.net
обсуждение исходный текст
Ответы Re: Something wrong with binding timestamp values  (Mark Lewis <mark.lewis@mir3.com>)
Список pgsql-jdbc
This code

PreparedStatement st = conn.prepareStatement("SELECT date_trunc('day', ?)");
st.setString(1, "2006-12-17");
ResultSet rs = st.executeQuery();

fails, as might be expected, because date_trunc(unknown, varchar)
doesn't exist.

But this code:

PreparedStatement st = conn.prepareStatement("SELECT date_trunc('day', ?)");
st.setTimestamp(1, new Timestamp(222222222));
ResultSet rs = st.executeQuery();

fails with postgresql-8.1-408.jdbc3.jar with

ERROR:  function date_trunc("unknown", "unknown") is not unique

It works correctly with postgresql-8.0-318.jdbc3.jar.

What is wrong here?  Why does a timestamp value end up being bound as
"unknown"?

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

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

Предыдущее
От: Brendon Bentley
Дата:
Сообщение: Re: Use Driver to Create database?
Следующее
От: Mark Lewis
Дата:
Сообщение: Re: Something wrong with binding timestamp values