Thread: Fwd: help on postgres regexp

Fwd: help on postgres regexp

From

Nicholas I

Date:

06 May 2010, 14:52:45

---------- Forwarded message ----------
From: Nicholas I <nicholas.domnic.i@gmail.com>
Date: Wed, May 5, 2010 at 8:35 AM
Subject: help
To: pgsql-sql@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.

that is
1
2
3

Thank You
Nicholas I

Re: Fwd: help on postgres regexp

From

Thom Brown

Date:

06 May 2010, 15:03:44

On 6 May 2010 15:52, Nicholas I <nicholas.domnic.i@gmail.com> wrote:

---------- Forwarded message ----------
From: Nicholas I <nicholas.domnic.i@gmail.com>
Date: Wed, May 5, 2010 at 8:35 AM
Subject: help
To: pgsql-sql@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.

that is
1
2
3

Thank You
Nicholas I

Use a regular expression:

SELECT substring('this is a test(22)' from '\([0-9]+\)');

This would return 22.

Regards

Thom