Re: help

From: Marcin Krawczyk <jankes(dot)mk(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-06-28 06:46:39
Message-ID: AANLkTinXN6HQ4aVZ8kVhTmCAM35WatyUNzW1w-CV66NT@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Or even simpler, or easier to understand:

SELECT trim(foo, '()') FROM foobar

pozdrowienia / regards / salutations
mk

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
>
>

In response to

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

Browse pgsql-sql by date

  From Date Subject
Next Message ced 2010-06-28 10:03:26 Outer join construction step :strange results
Previous Message silly sad 2010-06-28 05:29:03 Re: round(Numeric)