Postgres Pro
Downloads
Home   >   mailing lists

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 200410081207.26607.peter_e@gmx.net
Whole thread Raw
In response to when to use NULL and when to NOT NULL DEFAULT ''  (Miles Keaton <mileskeaton@gmail.com>)
Responses Re: when to use NULL and when to NOT NULL DEFAULT ''
Re: when to use NULL and when to NOT NULL DEFAULT ''
List pgsql-general
Tree view 
Am Freitag, 8. Oktober 2004 07:22 schrieb Miles Keaton:
> What's the prevailing wisdom & best-practice advice about when to let
> a varchar (or any) column be NULL, and when to make it NOT NULL
> DEFAULT '' (or '0000-00-00' or whatever) - in PostgreSQL?

Briefly, you always do the first and never do the second.

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

pgsql-general by date:

Previous
From: David Garamond
Date:
Subject: Re: 8.0 questions
Next
From: Terry Lee Tucker
Date:
Subject: Re: when to use NULL and when to NOT NULL DEFAULT ''