Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

Next:From: Kieran AshleyDate: 2005-01-12 19:00:36
Subject: Re: Problems with Quotes
Previous:From: Edmund BaconDate: 2005-01-12 18:46:53
Subject: Re: Problems with Quotes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group