Re: Using the REPLACE command to replace all vowels

From: Wayne Conrad <wconrad(at)yagni(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Using the REPLACE command to replace all vowels
Date: 2006-05-03 07:56:31
Message-ID: 20060503075631.GB23670@mail.yagni.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, May 03, 2006 at 09:38:47AM +0200, Magnus Hagander wrote:
> SELECT regexp_replace(your_string,'[aeiou]','','g') ...

I'll be darned. I've been looking for that function. I expected to
find it in the docs under "String Functions" with the other replace
functions. I'm surprised to find it under "Pattern Matching."

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joao Miguel Ferreira 2006-05-03 11:02:18 database size grows (even after vacuum (full and analyze))....
Previous Message Magnus Hagander 2006-05-03 07:38:47 Re: Using the REPLACE command to replace all vowels