Re: Problems with Quotes

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Edmund Bacon <ebacon(at)onesystem(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org, Kieran Ashley <krashley(at)space(dot)qinetiq(dot)com>
Subject: Re: Problems with Quotes
Date: 2005-01-12 18:58:47
Message-ID: 20050112185847.GA95755@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Kieran Ashley 2005-01-12 19:00:36 Re: Problems with Quotes
Previous Message Edmund Bacon 2005-01-12 18:46:53 Re: Problems with Quotes