Re: Boolean casting in 7.3 -> changed?

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: Boolean casting in 7.3 -> changed?
Дата
Msg-id
Pine.LNX.4.44.0211271943140.12428-100000@localhost.localdomain
Ответ на
Список
Дерево обсуждения
Boolean casting in 7.3 -> changed? Ian Barwick <barwick@gmx.net>
Re: Boolean casting in 7.3 -> changed? Tom Lane <tgl@sss.pgh.pa.us>
Re: Boolean casting in 7.3 -> changed? Ian Barwick <barwick@gmx.net>
Re: Boolean casting in 7.3 -> changed? Tom Lane <tgl@sss.pgh.pa.us>
Re: Boolean casting in 7.3 -> changed? Peter Eisentraut <peter_e@gmx.net>
Re: Boolean casting in 7.3 -> changed? David Walker <pgsql@grax.com>
Re: Boolean casting in 7.3 -> changed? David Wheeler <david@wheeler.net>
Re: Boolean casting in 7.3 -> changed? Tom Lane <tgl@sss.pgh.pa.us>
Re: Boolean casting in 7.3 -> changed? Ian Barwick <barwick@gmx.net>
Ian Barwick writes:

> "Casting integers to boolean (for example, 0::bool) is no longer allowed,
> use '0'::bool instead".

This advice would probably only cause more confusion, because we are now
moving into the direction that character strings are no longer acceptable
as numeric data.

Note that

x <> 0

is also a perfectly good way to convert integers to booleans, and a more
portable one at that.

Finally, you can always create your own cast.

-- 
Peter Eisentraut   peter_e@gmx.net


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: scott.marlowe
Дата:
FAQ