Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table group_views  (cwgv_group  bigint, cwgv_table bigint);

insert into group_views values (1, 0), (1, 1), (1, 3);

CREATE TABLE



INSERT 0 3


select COALESCE(MAX(case when cwgv_table = 0 then 1 end), 0)
     , COALESCE(MAX(case when cwgv_table = 1 then 1 end), 0)
     , COALESCE(MAX(case when cwgv_table = 2 then 1 end), 0)
     , COALESCE(MAX(case when cwgv_table = 3 then 1 end), 0)
     , COALESCE(MAX(case when cwgv_table = 4 then 1 end), 0)  
from group_views  
where cwgv_group = 1


coalesce
coalesce
coalesce
coalesce
coalesce


1
1
0
1
0



SELECT 1


select COALESCE(MAX(case when cwgv_table = 0 then 1 end), 0)
     , COALESCE(MAX(case when cwgv_table = 1 then 1 end), 0)
     , COALESCE(MAX(case when cwgv_table = 2 then 1 end), 0)
     , COALESCE(MAX(case when cwgv_table = 3 then 1 end), 0)
     , COALESCE(MAX(case when cwgv_table = 4 then 1 end), 0)  
from group_views  
where cwgv_group = 2


coalesce
coalesce
coalesce
coalesce
coalesce


0
0
0
0
0



SELECT 1