Fwd: help on postgres regexp

---------- Forwarded message ----------
From: Nicholas I <nicholas(dot)domnic(dot)i(at)gmail(dot)com>
Date: Wed, May 5, 2010 at 8:35 AM
Subject: help
To: pgsql-sql(at)postgresql(dot)org

Hi,

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

Thank You
Nicholas I