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
