Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas
Subject How to remove a set of characters in text-columns ?
Date
Msg-id 4E0CCE6F.70001@gmx.net
Whole thread Raw
Responses Re: How to remove a set of characters in text-columns ?  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-sql
Tree view 
Hi,
how can I remove a set of characters in text-columns ?
Say I'd like to remove { } ( ) ' " , ; . : !
Of course I can chain replace ( replace ( replace ( replace ( ... , '' ) 
.... and replace the chars one by one against an empty string ''.

There might be a more elegant way.
Is there ?


regards

pgsql-sql by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: best performance for simple dml
Next
From: Steve Crawford
Date:
Subject: Re: How to remove a set of characters in text-columns ?