Received: from symcom.com ([209.11.41.82]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB338em54420 for ; Sun, 2 Dec 2001 22:08:41 -0500 (EST) (envelope-from pgsql@symcom.com) Message-Id: <200112030308.fB338em54420@postgresql.org> Received: from WorldClient [209.11.41.82] by symcom.com [209.11.41.82] with SMTP (MDaemon.v3.5.0.R) for ; Sun, 02 Dec 2001 22:20:48 -0500 Date: Sun, 02 Dec 2001 22:20:48 -0500 From: "postgresql" To: "Stephan Szabo" , "Megalex" , pgsql-sql@postgresql.org Subject: Re: problems with single quotes.. X-Mailer: WorldClient Pro 2.2.1 In-Reply-To: <20011202142056.M84081-100000@megazone23.bigpanda.com> X-MDRemoteIP: 209.11.41.82 X-Return-Path: pgsql@symcom.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Archive-Number: 200112/15 X-Sequence-Number: 5838 but this is exactally correct behavior.....you can use either two single quotes to escape the quote or the backslash so..... ' '' \\ '' ' singlequote to start the sequence(string) two singlequotes to insert an escape then a singlequote (yields a single quote) a backslash to escape the following backslash (yields a single backslash) two singlequotes to insert an escape then a singlequote (yields a single quote) then ended by a single quote this is acting correctly..... Ted -----Original Message----- From: Stephan Szabo To: Megalex Date: Sun, 2 Dec 2001 14:21:33 -0800 (PST) Subject: Re: [SQL] problems with single quotes.. > On Thu, 4 Jan 2001, Megalex wrote: > > > i already tried escaping it.. but the problem is > > with the singlequote-backslash-singlequote combinations.. > > '''\\''' seems to insert a singlequote-backslash-singlquote > for me. > > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to > majordomo@postgresql.org >