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

Поиск
Список
Период
Сортировка
От David Garamond
Тема Re: when to use NULL and when to NOT NULL DEFAULT ''
Дата
Msg-id 4166A019.4000403@zara.6.isreserved.com
обсуждение исходный текст
Ответ на Re: when to use NULL and when to NOT NULL DEFAULT ''  (Michael Glaesemann <grzm@myrealbox.com>)
Ответы Re: when to use NULL and when to NOT NULL DEFAULT ''  (Michael Glaesemann <grzm@myrealbox.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: query gone haywire :)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: text + text