clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591563 fiddles created (45735 in the last week).

select version(); create table current (current_data text not null); create table expected_output (expected_outcome text not null); insert into current (current_data) values ('1,2,3'),('1,4'),('1,5,7'),('8,9,10'), ('10,11,15'); insert into expected_output (expected_outcome) values ('1,2,3,4,5,7'),('8,9,10,11,15');
version
PostgreSQL 13.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.4.1 20200928 (Red Hat 8.4.1-1), 64-bit
5 rows affected
2 rows affected
 hidden batch(es)


select * from current; select * from expected_output;
current_data
1,2,3
1,4
1,5,7
8,9,10
10,11,15
expected_outcome
1,2,3,4,5,7
8,9,10,11,15
 hidden batch(es)