Re: when to use NULL and when to NOT NULL DEFAULT ''

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/