Thanks to everyone who helped. I was using prepared statements with
I was using the setString() method to set the value to null, when I
needed to be using the setNull() method. It created the null values
that I needed.
On Tuesday, February 18, 2003, at 07:25 PM, Josh Berkus wrote:
>> I have a form that contains optional DATE fields. To enter null
>> values, I've tried null, 'null', '', '-', '0', 0, and each time I get
>> one of the following errors:
> NULL is correct, no quotes. Please post the actual insert statement
> you are sending; likely the problem is elsewhere.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2003-02-19 20:59:04|
|Subject: Re: Importing Postgres 7.1.1 DBs into Postgres 7.3.2 |
|Previous:||From: Guy Fraser||Date: 2003-02-19 19:06:56|
|Subject: Re: Passing arrays|