Thread: Boolean to integer conversion

JORGE MALDONADO wrote on 28.03.2012 19:20:
> Is it possible to convert a boolean field to integer? (True = 1,
> False = 0)
>
> In the following example, "price" is a non-zero numeric field and
> "status" is a boolean field. So that, when "status=False" then
> "final_price=0.00" and when "status=True" then "final_price <>
> 0.00".
>
> SELECT (price * status) AS final_price
>
> I know that I can use a "CASE WHEN..." statement but, in this case,
> it is not the solution I am looking for.
>

SELECT (price * status::int) AS final_price