Re: [GENERAL] Fwd: help on postgres regexp

2010-05-06 Thread Thom Brown
On 6 May 2010 15:52, Nicholas I wrote: > > > -- Forwarded message -- > From: Nicholas I > Date: Wed, May 5, 2010 at 8:35 AM > Subject: help > To: pgsql-...@postgresql.org > > > Hi, > > I have a table in which the data's are entered like, > > Example: > > One (1) > Two (2) > Three

[GENERAL] Fwd: help on postgres regexp

2010-05-06 Thread Nicholas I
-- Forwarded message -- From: Nicholas I Date: Wed, May 5, 2010 at 8:35 AM Subject: help To: pgsql-...@postgresql.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.