How can I convert boolean into 0 and 1 in Redshift?

Question

I guess I can do something like case when field then 1 else 0 end. But is that the only way?

Answer 1

select cast(b as integer)

or

select convert (integer, b)