Re: Using regexp_replace to remove small words - Mailing list pgsql-general

From Vick Khera
Subject Re: Using regexp_replace to remove small words
Date
Msg-id AANLkTinvWX83wvhVwA==xV6c_CrkuaSB1GKKS-e6jMm=@mail.gmail.com
Whole thread Raw
In response to RES: Using regexp_replace to remove small words  ("Henrique de Lima Trindade" <henrique@vivver.com.br>)
List pgsql-general
On Mon, Dec 13, 2010 at 7:24 AM, Henrique de Lima Trindade
<henrique@vivver.com.br> wrote:
> Your example works perfectly. But, I need Your help with on another situation.
> We're trying to create a plpgsql function with the expression. But, I'm getting a syntax error:

You're using $$ quoting for the function, and $$ quoting for the
string in the regexp.  Think of it like you're trying to embed a ' in
a string delimited by ' also.

pgsql-general by date:

Previous
From: "Henrique de Lima Trindade"
Date:
Subject: RES: Using regexp_replace to remove small words
Next
From: Hampus Wessman
Date:
Subject: Re: pg_dump order of rows