Re: How to remove a set of characters in text-columns ?

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to remove a set of characters in text-columns ?
Date: 2011-07-01 02:43:04
Message-ID: 4E0D3438.2060200@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Am 01.07.2011 04:17, schrieb Tim Landscheidt:
> besides the regexp_replace() solution mentioned by Charlie
> and Steve, you can also use TRANSLATE():
>
> | tim=# SELECT TRANSLATE('a{b''c"d!f', '{}()''",;.:!', '');

nice, 2 solutions for 1 problem. :)
my replace...replace... was a wee bit tedious ;)

thanks a lot to you, Charlie and Steve :)

regards
Andreas

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message gmb 2011-07-04 06:47:55 Usage of function retruning record in query
Previous Message Tim Landscheidt 2011-07-01 02:17:55 Re: How to remove a set of characters in text-columns ?