Re: Blank date field.. Help... - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Blank date field.. Help...
Date
Msg-id 200207170543.g6H5h2500877@candle.pha.pa.us
Whole thread Raw
In response to Blank date field.. Help...  (ryan@fdcsmail.darktech.org)
Responses Re: Blank date field.. Help...  (Richard Huxton <dev@archonet.com>)
List pgsql-general
ryan@fdcsmail.darktech.org wrote:
> Hi,
>   Is there any way that I can do, just to make my date columns to accept null/blank
>   values? I use the latest stable version.

Uh, you sure can.  Can you show us the query that is failing.  Unless
the column is marked as NOT NULL, inserting a NULL should be fine.  It
will not accept '', only NULL.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: ryan@fdcsmail.darktech.org
Date:
Subject: Blank date field.. Help...
Next
From: Tom Lane
Date:
Subject: Re: OIDs (Or: another RTFM question?)