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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
