clear markdown help donate comments/suggestions/bugs a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith?
By using dbfiddle, you agree to license everything you submit by Creative Commons CC0

create type tbl_t as table of varchar(100);

create table foo(bar varchar(100));

insert into foo(bar) values('A');
1 rows affected

insert into foo(bar) values('B');
1 rows affected

with w as (select 1 baz, cast(collect(bar) as tbl_t) qux from foo) select * from w union all select baz,null from w;
BAZ QUX

with w as (select 1 baz, dump(collect(bar),16) from foo) select * from w union all select * from w;
BAZ DUMP(COLLECT(BAR),16)
1 Typ=58 Len=19: c0,29,27,a,0,0,0,0,f8,b1,cc,e2,5c,7f,0,0,80,51,d2
1 Typ=58 Len=19: c0,29,27,a,0,0,0,0,f8,b1,cc,e2,5c,7f,0,0,80,51,d2