Thread: strip a character from text
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/
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 shakentogether, and running over, shall men pour into your lap. For by your standard of measure it will be measuredto 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