Re: BOOLEAN data type?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: BOOLEAN data type?
Дата
Msg-id web-37967@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на Re: BOOLEAN data type?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Tom,

> Are you taking into account that SQL booleans are actually
> three-valued?
> They can be TRUE, FALSE, or NULL (NULL taken as meaning "don't
> know").

That turned out not to be the issue, but that's good information to
have.  I'll need to remember to make all of my BOOLEAN columns NOT NULL
DEFAULT FALSE.

-Josh


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


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

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: BOOLEAN data type?
Следующее
От: Lonnie Cumberland
Дата:
Сообщение: g++ not working for postgresql extension languages?