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.', ' .''', '-')