Re: Insert NULL value with to_numeric()

Поиск
Список
Период
Сортировка
От Ghislain Bob Hachey
Тема Re: Insert NULL value with to_numeric()
Дата
Msg-id 1153367291.2234.356.camel@informationmanagement.pfnet.local
обсуждение исходный текст
Ответ на Re: Insert NULL value with to_numeric()  ("Aaron Bono" <postgresql@aranya.com>)
Список pgsql-admin
>
> Why use to_number or to_timestamp?  I assume you are using setString
> in your prepared statement.  In your Java code you can use setNull if
> the value is null and setInt or setLong or setTimestamp if it is not.
> Then you don't need the to_number or to_timestamp.

You're absolutely right.  I was trying to make it work with setString
first cause I'm new to java and it was easier at first look.  But I will
take your advice.

Thanks a lot for your time

Ghislain Hachey
>


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

Предыдущее
От: "Aaron Bono"
Дата:
Сообщение: Re: Insert NULL value with to_numeric()
Следующее
От: LiveShell
Дата:
Сообщение: biginteger to timestamp