Postgres Pro
Downloads
Home   >   mailing lists

Re: How to remove a set of characters in text-columns ? - Mailing list pgsql-sql

From Andreas
Subject Re: How to remove a set of characters in text-columns ?
Date
Msg-id 4E0D3438.2060200@gmx.net
Whole thread Raw
In response to Re: How to remove a set of characters in text-columns ?  (Tim Landscheidt <tim@tim-landscheidt.de>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Tim Landscheidt
Date:
Subject: Re: How to remove a set of characters in text-columns ?
Next
From: gmb
Date:
Subject: Usage of function retruning record in query