Re: Casting INT4 to BOOL...

Sean Chittenden <chitt@speakeasy.net> writes:
> Is there any reason why the backend doesn't cast an unquoted integer to
> a boolean value?

Hidden cross-category typecasts are evil.  I'd accept this as an
explicit cast ('e' in pg_cast) but not automatic.

Also, what about the other direction?  Providing a cast in only one
direction is pretty inconsistent.

            regards, tom lane