Geoff Winkless schrieb am 24.01.2019 um 12:45:
> The reason for that at least is that '1' and '0' are valid boolean values.
>
> https://www.postgresql.org/docs/9.5/datatype-boolean.html
>
> There's additional text describing why casts are chosen to be defined
> as implicit or not here
>
> https://www.postgresql.org/docs/9.5/typeconv-overview.html
>
> My own opinion is that non-0 should implicitly cast as true and 0
> should cast as false.
I strongly disagree - that would mimic MySQL's idiosyncrasies and would make such a query valid:
delete from orders
where 42;