unday, May 07, 2006 3:54 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Using the REPLACE command to replace all vowels
>
> Magnus Hagander wrote:
> >> Is there a way to make seperate replacements in 1 field in
> >> one command in SQL?
> >>
> &
Magnus Hagander wrote:
Is there a way to make seperate replacements in 1 field in
one command in SQL?
I need to remove all vowels (a,e,i,o,u) in a field. How would
I go about that?
Try something like
SELECT regexp_replace(your_string,'[aeiou]','','g') ...
(btw, if you want all vowels, don't
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 u
> Is there a way to make seperate replacements in 1 field in
> one command in SQL?
>
> I need to remove all vowels (a,e,i,o,u) in a field. How would
> I go about that?
Try something like
SELECT regexp_replace(your_string,'[aeiou]','','g') ...
(btw, if you want all vowels, don't forget 'y' :-P)
On 1 May 2006 13:16:15 -0700, EbGrooveCb <[EMAIL PROTECTED]> wrote:
Is there a way to make seperate replacements in 1 field in one command
in SQL?
I need to remove all vowels (a,e,i,o,u) in a field. How would I go
about that?
You can do all the replacements in a single SQL statement by nestin
Is there a way to make seperate replacements in 1 field in one command
in SQL?
I need to remove all vowels (a,e,i,o,u) in a field. How would I go
about that?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
