Re: when to use NULL and when to NOT NULL DEFAULT '' - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: when to use NULL and when to NOT NULL DEFAULT ''
Date
Msg-id 200410081400.26748.peter_e@gmx.net
Whole thread Raw
In response to Re: when to use NULL and when to NOT NULL DEFAULT ''  (Terry Lee Tucker <terry@esc1.com>)
List pgsql-general
Am Freitag, 8. Oktober 2004 12:20 schrieb Terry Lee Tucker:
> Why would you never define a column as NOT NULL, or am I misunderstanding
> what you are saying?

His question was, should one use null values or should one use artificially
reserved real data values to indicate missing values, as MySQL appears to
have recommended at some point.  My suggestion was to use null values.

Of course, if you don't want null values, you declare your column accordingly.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-general by date:

Previous
From: "Raymond O'Donnell"
Date:
Subject: Re: European dates with Win32 version
Next
From: Peter Eisentraut
Date:
Subject: Re: text + text