Re: BUG REPORT: Unable to cast boolean::smallint - Mailing list pgsql-bugs

On 11/5/14 5:31 PM, David G Johnston wrote:
> Tom Lane-2 wrote
>> Well, there are also not direct casts provided from boolean to bigint,
>> numeric, real, or double precision ;-).  I'm not terribly excited about
>> this.
>
> So why is there one for Boolean to int?

That can be useful for e.g.  CHECK (bool1::int + bool2::int + bool3::int
= 1).


.marko