updating table where one date field is null - Mailing list pgsql-novice

From richard terry
Subject updating table where one date field is null
Date
Msg-id 200807180754.11669.rterry@gnumed.net
Whole thread Raw
Responses Re: updating table where one date field is null  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-novice
I'm passing some information to postges (from gambas basic), which gets the
data from date type

eg date1 as date
     date2 as date

(IN the postgres database the default on the date field is null)

my problem is that postgres baulks when I"ve not put a date into one of the
gambas date variables with the message:

"invalid syntax for type date '00:00:00'"

my sql is far more complex but reduced to the date part reads something like
this

insert into mytable (date1, date2) values

('01/01/2008','00:00:00')

I wondered if anyone could volunteer a solution

Regards

Richard

pgsql-novice by date:

Previous
From: John DeSoi
Date:
Subject: Re: Stopping a transaction as soon as an error occurs
Next
From: Stephan Szabo
Date:
Subject: Re: updating table where one date field is null