Re: How to convert a binary filed to an integer field?

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: How to convert a binary filed to an integer field?
Дата
Msg-id AANLkTi=HtqOBDZPHzSPgHb=VYnwQRyrCunxcgRZdkP3A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to convert a binary filed to an integer field?  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
Дерево обсуждения 
> I am going to assume that by binary you mean boolean. If so it already has
> three states NULL,True,False.

Uh, not really, no. NULL indicates the absence or indeterminacy of a
state, and has a number of properties that make it unsuitable for
representing anything other than that.

Use an enum.


--
Regards,
Peter Geoghegan

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: How to convert a binary filed to an integer field?
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: Differences between to_tsquery() and plainto_tsquery() when it comes to applying an index?