Greetings,

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

Thx.

Nhan NGO DINH


__________________________________________________________________
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/




Wed, 18 Sep 2002 12:18:48 +0200
nngodinh@tiscali.it
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 


18 Sep 2002 13:30:49 +0100
Oliver Elphick <olly@lfix.co.uk>
Re: strip a character from text
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/




Wed, 18 Sep 2002 14:43:51 +0200
nngodinh@tiscali.it
Re: strip a character from text
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



Wed, 18 Sep 2002 09:41:14 -0700
Joe Conway <mail@joeconway.com>
Re: strip a character from text