Received: from maia.hub.org (maia-4.hub.org [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 7ECDB63372D
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed,  5 May 2010 00:05:36 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 56305-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed,  5 May 2010 03:05:29 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com
	[209.85.212.46])
	by mail.postgresql.org (Postfix) with ESMTP id 1727863364F
	for <pgsql-sql@postgresql.org>; Wed,  5 May 2010 00:05:28 -0300 (ADT)
Received: by vws12 with SMTP id 12so613836vws.19
	for <pgsql-sql@postgresql.org>; Tue, 04 May 2010 20:05:28 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:date:message-id
	:subject:from:to:content-type;
	bh=Zti91JWdcwajphB5SKJ/PxxKXuS8tVzvWwFixLqneHE=;
	b=viA1G5xnhxoyg1++3E2bG08FRlvrVUVezr2aa+cHWAIHDkBYUTqmKihuk6MdKmMhav
	Iz8j+0053U7JnP2nu80Ji84w1wkOTtgX0vzXqs+wfM2pf375umVHRvWZ+zhrDFeiXAb/
	R/tf7B9/Em5jBGHQD0GlNbkqmgWekX7qio7Cg=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=qWKPxVez8qBG9yHb/I6xOFCCJOAgZ7HLOJI8oDMjkmtHYZjqb9qRy+3SXlbC98BLQ2
	SKC4r9I2VbYgR+kXeCWvb5RAaH/MzbgCUzPP9WdXrheSh89UhZav/BOaZ0hwPzTU/hnL
	4HchfumOVOG0iXAJzO7luVMhwILGV6a6NsYB4=
MIME-Version: 1.0
Received: by 10.220.128.24 with SMTP id i24mr11920465vcs.153.1273028728018;
	Tue, 04 May 2010 20:05:28 -0700 (PDT)
Received: by 10.220.64.103 with HTTP; Tue, 4 May 2010 20:05:27 -0700 (PDT)
Date: Wed, 5 May 2010 08:35:27 +0530
Message-ID: <z2ze13d0d11005042005p21c76315ha13f12199f9cebe5@mail.gmail.com>
Subject: help
From: Nicholas I <nicholas.domnic.i@gmail.com>
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=0016e68eef271fccd20485d019cd
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.011 tagged_above=-5 required=5
	tests=BAYES_20=-0.001, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001,
	RCVD_IN_DNSWL_NONE=-0.0001, T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: 
X-Archive-Number: 201005/29
X-Sequence-Number: 34077

--0016e68eef271fccd20485d019cd
Content-Type: text/plain; charset=ISO-8859-1

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

--0016e68eef271fccd20485d019cd
Content-Type: text/html; charset=ISO-8859-1

Hi,<br><br>I have a table in which the data&#39;s are entered like,<br><br>Example:<br><br>One (1)<br>Two (2)<br>Three (3)<br><br>I want to extract the data which is only within the parentheses.<br><br>that is <br>1<br>2<br>
3<br><br><br>Thank You<br>Nicholas I<br><br>

--0016e68eef271fccd20485d019cd--