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

From David Garamond
Subject Re: when to use NULL and when to NOT NULL DEFAULT ''
Date
Msg-id 4166A019.4000403@zara.6.isreserved.com
Whole thread Raw
In response to Re: when to use NULL and when to NOT NULL DEFAULT ''  (Michael Glaesemann <grzm@myrealbox.com>)
Responses Re: when to use NULL and when to NOT NULL DEFAULT ''  (Michael Glaesemann <grzm@myrealbox.com>)
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: query gone haywire :)
Next
From: Tom Lane
Date:
Subject: Re: text + text