Re: Problems with Quotes - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: Problems with Quotes
Date
Msg-id 20050112185847.GA95755@winnie.fuhr.org
Whole thread Raw
In response to Re: Problems with Quotes  (Edmund Bacon <ebacon@onesystem.com>)
List pgsql-sql
On Wed, Jan 12, 2005 at 11:46:53AM -0700, Edmund Bacon wrote:

> Perhaps you are forgetting to double up on your quote chars?

If that's the problem then 8.0's dollar quoting will simplify
the situation:

CREATE OR REPLACE FUNCTION foo(text) RETURNS text AS $$
SELECT replace($1, '"', '');
$$ LANGUAGE sql;

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/


pgsql-sql by date:

Previous
From: Kieran Ashley
Date:
Subject: Re: Problems with Quotes
Next
From: John DeSoi
Date:
Subject: Re: Problems with Quotes