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

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: when to use NULL and when to NOT NULL DEFAULT ''
Дата
Msg-id 975499A0-192E-11D9-A09B-000A95C88220@myrealbox.com
обсуждение исходный текст
Ответ на Re: when to use NULL and when to NOT NULL DEFAULT ''  (David Garamond <lists@zara.6.isreserved.com>)
Ответы Re: when to use NULL and when to NOT NULL DEFAULT ''  (David Garamond <lists@zara.6.isreserved.com>)
Список pgsql-general
On Oct 8, 2004, at 10:19 PM, David Garamond wrote:

> 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. :)

Michael Glaesemann
grzm myrealbox com


В списке pgsql-general по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: text + text
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Question about timezones