Re: PreparedStatement error for date parameter with overlaps

Поиск
Список
Период
Сортировка
От Simon Mitchell
Тема Re: PreparedStatement error for date parameter with overlaps
Дата
Msg-id BANLkTinJBQFH5exg7r-8VxHc+u4L_m+H9w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PreparedStatement error for date parameter with overlaps  (Craig Ringer <craig@postnewspapers.com.au>)
Ответы Re: PreparedStatement error for date parameter with overlaps
Re: PreparedStatement error for date parameter with overlaps
Список pgsql-jdbc
Дерево обсуждения
Bingo

thanks guys, this works fine, obviously I had no idea what i was doing,
no need to run the date function on a date.
SELECT (CAST(? AS date), ?::date) OVERLAPS (date(?), date(?)) works fine.

So from what I understand using the date function in jdbc stuff requires brackets like most functions do,
but the psql is happy for me to use the date function with or without brackets.
Postgresql docs examples seem to be all with out brackets.


On Tue, May 31, 2011 at 15:27, Craig Ringer <craig@postnewspapers.com.au> wrote:
On 31/05/11 11:12, Simon Mitchell wrote:

> Both   ?::date and  CAST(? AS date) fail in java.
>
>    ?::date works fine in psql, but  CAST(? AS date) fails in psql.
>
> SELECT (date CAST('2001-02-16' AS date), date ('2001-12-21')) OVERLAPS
> (date ('2001-10-30'), date ('2002-10-30'));
> ERROR:  syntax error at or near "CAST"

You wrote:

SELECT (date CAST('2001-02-16' AS date) ...
       ^^^^
      whoops

you should write:

SELECT (CAST('2001-02-16' AS date) ...

See how that goes.

--
Craig Ringer



--
simon

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