Re: spring a string to rows (Postgresql 8.4)

[Moshe Jacobson <moshe@xxxxxxxxxxxx>]

select id, unnest(regexp_split_to_array(col1, ',\s+'))

On Mon, Jan 7, 2013 at 2:44 PM, Emi Lu <emilu@xxxxxxxxxxxxxxxxx> wrote:

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




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--

Moshe Jacobson
Nead Werx, Inc. | Senior Systems Engineer

2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@xxxxxxxxxxxx | www.neadwerx.com