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

From: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
To: Michael Glaesemann <grzm(at)myrealbox(dot)com>
Cc: Miles Keaton <mileskeaton(at)gmail(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: when to use NULL and when to NOT NULL DEFAULT ''
Date: 2004-10-08 14:11:37
Message-ID: 4166A019.4000403@zara.6.isreserved.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Glaesemann wrote:
>>> In any case, one would never use NULL. Either the domain includes a
>>> value for all possible values (including N/A) or you set up the db
>>> schema appropriately.
>>
>> Hm, that can be painful. What if I have ten optional attributes;
>> separate them to ten different tables?
>
> Strictly? That's how I understand it. Whether or not it's performant
> under PostgreSQLis another matter. :)

The relationists' SQL replacement had better have more convenient JOIN
syntax then. :-)

--
dave

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-08 14:16:42 Re: text + text
Previous Message Tom Lane 2004-10-08 14:11:36 Re: query gone haywire :)