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

From David Walker
Subject Re: Boolean casting in 7.3 -> changed?
Date
Msg-id 200211271834.12241.pgsql@grax.com
Whole thread Raw
In response to Re: Boolean casting in 7.3 -> changed?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Boolean casting in 7.3 -> changed?
List pgsql-hackers
Does this mean that in the future '342' may not be valid as an insert into a 
numeric field and that we should be using 342 instead?

On Wednesday 27 November 2002 05:07 pm, (Via wrote:
> 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.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Planning for improved versions of IN/NOT IN
Next
From: "Marc G. Fournier"
Date:
Subject: v7.3 Packaged ...