Skip site navigation (1) Skip section navigation (2)

date default

From: Robert Morgan <robert_(at)ihug(dot)co(dot)nz>
To: postgres <pgsql-novice(at)postgresql(dot)org>
Subject: date default
Date: 2004-05-27 04:30:39
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I'm updating a table that has a field which is datatype 'date' this 
field maybe filled out or not before update. If the field  is left blank 
I get an error, if I test to see if the field is empty and if it is, set 
the value to 0001/01/01 then postgres will accept this. I would rather 
the field remained empty but setting the field to 'null' is not accepted 
by postgres. Im using php to test and set the value.



pgsql-novice by date

Next:From: Oliver ElphickDate: 2004-05-27 10:02:01
Subject: Re: date default
Previous:From: Nabil SayeghDate: 2004-05-26 11:03:43
Subject: Re: questions on crosstab/coss-referenced queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group