From: Andreas <maps.on@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: How to remove a set of characters in text-columns ?
Date: Fri, 01 Jul 2011 04:43:04 +0200
Message-ID: <4E0D3438.2060200@gmx.net> (raw)
In-Reply-To: <m37h82lp64.fsf@passepartout.tim-landscheidt.de>
References: <4E0CCE6F.70001@gmx.net>
<m37h82lp64.fsf@passepartout.tim-landscheidt.de>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: maps.on@gmx.net
Subject: Re: How to remove a set of characters in text-columns ?
In-Reply-To: <4E0D3438.2060200@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox