Re: Insert NULL value with to_numeric()

From: Ghislain Bob Hachey <ghachey(at)pipolfastaem(dot)gov(dot)sb>
To: Aaron Bono <postgresql(at)aranya(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Insert NULL value with to_numeric()
Date: 2006-07-20 03:48:11
Message-ID: 1153367291.2234.356.camel@informationmanagement.pfnet.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Omer Mustafa 2006-07-20 07:18:39 Connection refused. Check that the hostname and port are correct
Previous Message Aaron Bono 2006-07-20 01:24:56 Re: Insert NULL value with to_numeric()