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

From Robert Treat
Subject Re: Blank date field.. Help...
Date
Msg-id 1026914465.21423.87.camel@camel
Whole thread Raw
In response to Blank date field.. Help...  (ryan@fdcsmail.darktech.org)
List pgsql-general
Unless you have stated NOT NULL in your table definition, you should be
able to enter NULL's. If you have stated NOT NULL, you'll need to
recreate the table.

CREATE TABLE "nulldatetest" (
   "withnull" date,
   "withoutnull" date NOT NULL
);

INSERT INTO "nulldatetest" ("withnull", "withoutnull") VALUES (NULL,
'2002-07-17')

Robert Treat

On Wed, 2002-07-17 at 09:30, 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.
>
> Ryan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster




pgsql-general by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Fortran functions?
Next
From: Doug McNaught
Date:
Subject: Re: dropping anonymous constraints