create table ccc (
  id serial primary key,
  a1 int,
  a2 int,
  a3 int
);
insert into ccc values(default,  0 ,  0 ,  0 );
insert into ccc values(default,  0 ,  1 ,  0 );
insert into ccc values(default,  1 ,  0 ,  1 );
insert into ccc values(default,  1 ,  1 ,  1 );

create type ccc_values as (id int, i int, a int);

CREATE OR REPLACE FUNCTION get_ccc_values() RETURNS setof ccc_values AS $_$
DECLARE
  rec RECORD;
  retv ccc_values;
BEGIN
  for rec in (SELECT * from ccc) loop
    retv := (rec.id,  1 , rec.a1); return next retv;
    retv := (rec.id,  2 , rec.a2); return next retv;
    retv := (rec.id,  3 , rec.a3); return next retv;
    --...--
  end loop;
  return;
END;
$_$ LANGUAGE plpgsql VOLATILE;

select * from get_ccc_values();

id	i	a
----------------
1	1	0
1	2	0
1	3	0
2	1	0
2	2	1
2	3	0
3	1	1
3	2	0
3	3	1
4	1	1
4	2	1
4	3	1

create view ccc_values_view as
select id,  1  as i, a1 as a from ccc
union all select id,  2 , a2 from ccc
union all select id,  3 , a3 from ccc;

select * from ccc_values_view where id= 12345 ;
select * from ccc_values_view where i in ( 1 , 3 );