Fwd: Need a help in regexp - Mailing list pgsql-general

---------- Forwarded message ----------
From: Nicholas I <nicholas.domnic.i@gmail.com>
Date: Thu, May 6, 2010 at 8:18 PM
Subject: Need a help in regexp
To: pgsql-sql@postgresql.org


Hi,

Need a help in regexp!

I have a table in which the data's are entered like,

Example:

One (1)
Two (2)
Three (3)

I want to extract the data which is only within the parentheses.

that is
1
2
3

i have written a query,
select regexp_matches(name,'([^(]+)([)]+)','g') from table;
which outputs the data as,
{"test"}
{"test2"}


Thank You
Nicholas I