Re: Replace string

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: "PostgreSQL SQL List" <pgsql-sql(at)postgresql(dot)org>
Cc: "PostgreSQL Admin" <postgres(at)productivitymedia(dot)com>
Subject: Re: Replace string
Date: 2007-04-12 05:29:13
Message-ID: a55915760704112229r12f0afcdtabce08c48ca3583e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 4/10/07, PostgreSQL Admin <postgres(at)productivitymedia(dot)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.', ' .''', '-')

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Dmitry Turin 2007-04-12 11:23:20 un-triviality is saved
Previous Message A. Kretschmer 2007-04-12 05:12:50 Re: Replace string