Re: Boolean casting in 7.3 -> changed? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Boolean casting in 7.3 -> changed?
Date
Msg-id Pine.LNX.4.44.0211271943140.12428-100000@localhost.localdomain
Whole thread Raw
In response to Re: Boolean casting in 7.3 -> changed?  (Ian Barwick <barwick@gmx.net>)
Responses Re: Boolean casting in 7.3 -> changed?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Boolean casting in 7.3 -> changed?  (David Walker <pgsql@grax.com>)
List pgsql-hackers
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fw: PostgreSQL 7.3 Platform Testing
Next
From: "scott.marlowe"
Date:
Subject: Re: [spam] Re: [mail] Re: Native Win32 sources