On 06/30/2011 12:28 PM, Andreas wrote: > 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 > Look at regexp_replace() http://www.postgresql.org/docs/9.0/static/functions-string.html http://www.postgresql.org/docs/9.0/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP Cheers, Steve
pgsql-sql by date:
Соглашаюсь с условиями обработки персональных данных