Convert bool to int in postgresql [duplicate]

December 12, 2023 by Tarik

Try boolean_col::int:

SELECT
item.item_number, SUM(item.item_active::int)
FROM 
public.item
GROUP BY item.item_number;