Fwd: Need a help in regexp

---------- Forwarded message ----------
From: Nicholas I <nicholas(dot)domnic(dot)i(at)gmail(dot)com>
Date: Thu, May 6, 2010 at 8:18 PM
Subject: Need a help in regexp
To: pgsql-sql(at)postgresql(dot)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