Emi Lu wrote on 07.01.2013 20:44:
Hello,Is there a function to split a string to different rows? For example, t1(id, col1) values(1, 'a, b, c'); select id, string_split_to_row(col1, ','); Return: ========= 1, a 1, b 1, c Thanks alot! Emi
select id, regexp_split_to_table(col1, ',') from t1; -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
