Received: from correoserver.interlink.es ([194.224.34.3]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g080LvB23031 for ; Mon, 7 Jan 2002 19:21:57 -0500 (EST) (envelope-from lmc@interlink.es) Received: from there (unverified [80.59.224.24]) by correoserver.interlink.es (Rockliffe SMTPRA 4.5.4) with SMTP id for ; Tue, 8 Jan 2002 01:17:40 +0100 Message-ID: Content-Type: text/plain; charset="iso-8859-1" From: Luis Miguel =?iso-8859-1?q?Casta=F1eda?= Reply-To: lmc@nova.es Organization: Quantum Leap To: Subject: Re: problems with single quotes.. Date: Tue, 8 Jan 2002 01:21:58 +0100 X-Mailer: KMail [version 1.3.1] References: <20011201182212.R74581-100000@megazone23.bigpanda.com> <20011202073819.28521.qmail@gnumed.dhs.org> <003401c07687$8631ff60$0301a8c0@klanomega.com> In-Reply-To: <003401c07687$8631ff60$0301a8c0@klanomega.com> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id g080O8C23182 X-Archive-Number: 200201/122 X-Sequence-Number: 6211 El Thursday 04 January 2001 08:50, Megalex escribió: > i already tried escaping it.. but the problem is > with the singlequote-backslash-singlequote combinations.. I use something like this, and works fine for me: create function quote(text)    returns text    as '    DECLARE         quote text;    BEGIN         quote := ichar(39); -- quote         return quote  || $1 || quote;    END;'    language 'plpgsql'; -- Saludos, lmc@nova.es _________________________________________________________________ I've lost my faith in nihilism