How to count, how may true and false for the field public in postgresql user table i have tried this query
select
sum(case when false then 1 else 0 end) as false,
sum(case when true then 1 else 0 end) as true
from public.user;
but am not getting any value and if i remove public from query then i will get correct counts only i have value true
table : name| DOB | public
values : bb | 20/2/1991/| true
op : true = 1 and false = 0
but am getting the same answer when i make public as false
table : name| DOB | public
values : bb | 20/2/1991/| false
op : true = 1 and false = 0
so someone please help me to solve this