Postgres Pro
Downloads
Home   >   mailing lists

Re: Replace string - Mailing list pgsql-sql

From A. Kretschmer
Subject Re: Replace string
Date
Msg-id 20070412051250.GB27660@a-kretschmer.de
Whole thread Raw
In response to Replace string  (PostgreSQL Admin <postgres@productivitymedia.com>)
Responses Re: Replace string  (PostgreSQL Admin <postgres@productivitymedia.com>)
List pgsql-sql
Tree view 
am  Tue, dem 10.04.2007, um 16:40:41 -0400 mailte PostgreSQL Admin folgendes:
> Hi,
> 
> I want to replace a title with dashes and also remove punctuation. 
> 
> e.g,  The blue fox's fur. -> The-blue-fox-fur

test=*# select regexp_replace(regexp_replace('The blue fox\'s fur.', ' ', '-', 'g'), '\\.', '');  regexp_replace
--------------------The-blue-fox's-fur
(1 row)


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-sql by date:

Previous
From: PostgreSQL Admin
Date:
Subject: Replace string
Next
From: "Rodrigo De León"
Date:
Subject: Re: Replace string