Re: [Firebird-devel] Casting BOOLEAN

2020-05-27 Thread Mark Rotteveel
On 27-05-2020 16:31, Emil Totev wrote: It seems that it is only possible to CAST() from/to boolean as char/varchar (values 'TRUE' and 'FALSE'), and the same also applies to the new SET BIND OF BOOLEAN TO type-to. Is this restricted by the SQL standard? Wouldn't it also make sense to be able t

[Firebird-devel] Casting BOOLEAN

2020-05-27 Thread Emil Totev
It seems that it is only possible to CAST() from/to boolean as char/varchar (values 'TRUE' and 'FALSE'), and the same also applies to the new SET BIND OF BOOLEAN TO type-to. Is this restricted by the SQL standard? Wouldn't it also make sense to be able to cast /set bind of booleans to any numeric