Re: Replace string - Mailing list pgsql-sql

From Rodrigo De León
Subject Re: Replace string
Date
Msg-id a55915760704112229r12f0afcdtabce08c48ca3583e@mail.gmail.com
Whole thread Raw
In response to Replace string  (PostgreSQL Admin <postgres@productivitymedia.com>)
List pgsql-sql
On 4/10/07, PostgreSQL Admin <postgres@productivitymedia.com> wrote:
> Hi,
>
> I want to replace a title with dashes and also remove punctuation.
>
> e.g,  The blue fox's fur. -> The-blue-fox-fur
>
>
> Thanks for any input,
> J

SELECT translate('The blue fox''s fur.', ' .''', '-')


pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Replace string
Next
From: Dmitry Turin
Date:
Subject: un-triviality is saved