strip a character from text

On Wed, 2002-09-18 at 11:18, nngodinh@tiscali.it wrote:

Greetings,

Does anyone know a function that strips ANY occurence of a given character
from a TEXT?

It sounds like a job for a PL/Perl function.

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Give, and it shall be given unto you; good measure,
pressed down, and shaken together, and running over,
shall men pour into your lap. For by your standard of
measure it will be measured to in return."
Luke 6:38

I'm about to write a C function... If I can't found alternatives.

-- Messaggio Originale --
Subject: Re: [HACKERS] strip a character from text
From: Oliver Elphick <olly@lfix.co.uk>
To: nngodinh@tiscali.it
Cc: pgsql-hackers@postgresql.org
Date: 18 Sep 2002 13:30:49 +0100

On Wed, 2002-09-18 at 11:18, nngodinh@tiscali.it wrote:

Greetings,

Does anyone know a function that strips ANY occurence of a given character
from a TEXT?

It sounds like a job for a PL/Perl function.

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Give, and it shall be given unto you; good measure,
pressed down, and shaken together, and running over,
shall men pour into your lap. For by your standard of
measure it will be measured to in return."
Luke 6:38

__________________________________________________________________
Tiscali Ricaricasa
la prima prepagata per navigare in Internet a meno di un'urbana e
risparmiare su tutte le tue telefonate. Acquistala on line e non avrai
nessun costo di attivazione né di ricarica!
http://ricaricasaonline.tiscali.it/

nngodinh@tiscali.it wrote:

I'm about to write a C function... If I can't found alternatives.

Note that in 7.3 (in beta now) there is a new replace() function which will do
this:

regression=# select replace('abcdefghabcdef','c','');
replace
--------------
abdefghabdef

Joe