Split a string to rows? - Mailing list pgsql-sql

From Emi Lu
Subject Split a string to rows?
Date
Msg-id 50EB25B5.5020502@encs.concordia.ca
Whole thread Raw
Responses Re: Split a string to rows?
Re: Split a string to rows?
List pgsql-sql
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




pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Query execution based on a condition
Next
From: Steve Crawford
Date:
Subject: Re: Split a string to rows?