Postgres Pro
Downloads
Home   >   mailing lists

Easier way to 'strip' on multiple matches? - Mailing list pgsql-sql

From Marc G. Fournier
Subject Easier way to 'strip' on multiple matches?
Date
Msg-id 20050109143121.G6902@ganymede.hub.org
Whole thread Raw
List pgsql-sql
Tree view 
I need to strip out all spaces, and all \' from a string ... is there an 
easier way then doing:

select lower(replace(replace(name, ' ', ''), '\\\'', '')) from business;

Thanks ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

pgsql-sql by date:

Previous
From: "Dmitri Bichko"
Date:
Subject: Question about insert/update RULEs.
Next
From: "none none"
Date:
Subject: TEXT blob extraction in ecpg