On Jan 12, 2005, at 1:08 PM, Kieran Ashley wrote:
I've tried using the replace() function to get rid of the ", but I can't figure out how to use it without throwing an error. I tried
replace(col_name, '\"', '')
and several other permutations but to no avail, do I need to use something like an ASCII character code in order to get rid of a quote? If so which one, and if not, is there a better solution?
Try '"' as in
select replace('this "is" it', '"', '');
replace
------------
this is it
(1 row)
John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
