OK, will do that. Was trying to avoid program changes, but can't make it work any other way.
A MySQL-ism. Thanks for your help.
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Mon 1/31/2005 2:02 PM
To: Van Ingen, Lane
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Date / Time Data Type
"Van Ingen, Lane" <lvaningen@ESNCC.com> writes:
> updatedTime timestamp NOT NULL default '0000-00-00 00:00:00', <------ rejected
Instead of using a blatantly invalid timestamp value to mean "no data",
why don't you use NULL?
regards, tom lane