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

Поиск
Список
Период
Сортировка
От Miles Keaton
Тема when to use NULL and when to NOT NULL DEFAULT ''
Дата
Msg-id 59b2d39b04100722222aba715d@mail.gmail.com
обсуждение исходный текст
Ответы Re: when to use NULL and when to NOT NULL DEFAULT ''  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-general
PG peeps:

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?





{Moving to PG from MySQL where we were always advised to use NOT NULL
to save a byte or something.  But that was years ago so sorry for the
stupid-sounding question, but I had to ask.}

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Question from a newbie
Следующее
От: Brian Morton
Дата:
Сообщение: Re: interfaces for python