On 6 May 2010 15:52, Nicholas I <nicholas.domnic.i@xxxxxxxxx> wrote:
Use a regular _expression_:
SELECT substring('this is a test(22)' from '\([0-9]+\)');
This would return 22.
Regards
Thom
---------- Forwarded message ----------
From: Nicholas I <nicholas.domnic.i@xxxxxxxxx>
Date: Wed, May 5, 2010 at 8:35 AM
Subject: help
To: pgsql-sql@xxxxxxxxxxxxxx
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
