Re: Casting INT4 to BOOL...

>> 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.

Alrighty.  Do you want an updated patch for the single character tweak
or can you futz with it before committing?  :)

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

Ah... well, if you want that, I can provide that too.  Personally, I
could care less about the BOOL->INT direction than INT->BOOL.  In C++,
any bool value is either 0 or 1 and you can do such weirdness
(brokeness?) as:

bool val = false;
if (val == 0) { /* blah */ }

Anyway, with Qt, it converts bool values to integers.  I think Qt's
probably right on this front in that the value 1 should be considered
true and 0 should be considered false.  My $0.02.  -sc

--
Sean Chittenden