Re: Using regexp_replace to remove small words

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Using regexp_replace to remove small words
Date: 2010-12-13 13:44:49
Message-ID: AANLkTinpAhMSQjtOAGbXjK0WOSoV0sTw0bpgoGexjsm+@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Dec 10, 2010 at 5:59 PM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> select regexp_replace('Tommy Lee Jones', $$\y\w{2,3}\y$$, ' ', 'g' );
>

speaking of regular expressions... the other day I was trying to find
where the 'flags' option to regexp_replace() is described, but I
cannot find it in the 9.0 manual in any obvious place. it is not
described in the string functions section, nor in the regexp section.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adarsh Sharma 2010-12-13 13:47:03 Problem while pg_xlog directory
Previous Message paulo matadr 2010-12-13 13:22:24 Cluster with LATIN1 and UTF-8