Re: help

From: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>
To: Nicholas I <nicholas(dot)domnic(dot)i(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: help
Date: 2010-05-07 15:24:30
Message-ID: s2u92869e661005070824l8f2d7139ibe75f79b02ecedd2@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

select substring( data from '\((.*)\)' ) from table;

2010/5/5 Nicholas I <nicholas(dot)domnic(dot)i(at)gmail(dot)com>:
> 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
>
>

--
Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/

In response to

  • help at 2010-05-05 03:05:27 from Nicholas I

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma 2010-05-07 16:33:58 Celko take on EAV
Previous Message Tom Lane 2010-05-06 21:13:40 Re: Column Specific Update Trigger Routine