plbuild/plcore_overlap.pg.sql

2 lines
164 B
SQL

select stlc,jsonb_agg(distinct substring(listcode,1,1)) from rlarp.plcore group by stlc having jsonb_array_length(jsonb_agg(distinct substring(listcode,1,1))) > 1;