Postgres Pro
Downloads
Home   >   mailing lists

Re: Insert NULL value with to_numeric() - Mailing list pgsql-admin

From Ghislain Bob Hachey
Subject Re: Insert NULL value with to_numeric()
Date
Msg-id 1153367291.2234.356.camel@informationmanagement.pfnet.local
Whole thread Raw
In response to Re: Insert NULL value with to_numeric()  ("Aaron Bono" <postgresql@aranya.com>)
List pgsql-admin
Tree view 
>
> 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 by date:

Previous
From: "Aaron Bono"
Date:
Subject: Re: Insert NULL value with to_numeric()
Next
From: LiveShell
Date:
Subject: biginteger to timestamp