Received: from mgate2.uni-hannover.de (mgate2.uni-hannover.de [130.75.2.5]) by postgresql.org (Postfix) with ESMTP id 3F78347591C for ; Thu, 25 Apr 2002 11:57:29 -0400 (EDT) Received: from wega.itp.uni-hannover.de by mgate2.uni-hannover.de with LocalSMTP (PP) with ESMTP; Thu, 25 Apr 2002 17:57:19 +0200 Received: from mirzam.itp.uni-hannover.de (mirzam.itp.uni-hannover.de [130.75.25.94]) by wega.itp.uni-hannover.de (AIX4.3/UCB 8.8.8/8.8.8) with ESMTP id RAA12576 for ; Thu, 25 Apr 2002 17:57:18 +0200 Received: (from kreutzm@localhost) by mirzam.itp.uni-hannover.de (8.11.6/8.9.3) id g3PFvIA31432 for pgsql-sql@postgresql.org; Thu, 25 Apr 2002 17:57:18 +0200 Date: Thu, 25 Apr 2002 17:57:18 +0200 From: Helge Kreutzmann To: pgsql-sql@postgresql.org Subject: Re: Proper quoting of \e ? Message-ID: <20020425175718.B31354@itp.uni-hannover.de> References: <20020425122253.A29150@itp.uni-hannover.de> <200204251547.g3PFlG317946@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-md5; protocol="application/pgp-signature"; boundary="t4apE7yKrX2dGgJC" Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <200204251547.g3PFlG317946@candle.pha.pa.us>; from pgman@candle.pha.pa.us on Thu, Apr 25, 2002 at 11:47:16AM -0400 X-Public-Key-URL: http://www.itp.uni-hannover.de/~kreutzm/data/kreutzm.gpg X-homepage: http://www.itp.uni-hannover.de/~kreutzm X-Archive-Number: 200204/308 X-Sequence-Number: 7572 --t4apE7yKrX2dGgJC Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Apr 25, 2002 at 11:47:16AM -0400, Bruce Momjian wrote: > > I took care of quoting "`" but recently stumpled about "\e" which I > > have problems working with. Example (in psql, but in php it is the same= ): > >=20 > > SELECT title from written_by where title like 'An equation of state {\%= '; > > title > > -----------------------------------------------------------------------= -------------------------- > > An equation of state {\em \`a la} Carnahan-Starling for a five-dimensio= nal fluid of hard hyperspheres > > (1 row) > >=20 > > works, but if I take one character more (or, later, the entire title), > > it does not: > >=20 > > SELECT title from written_by where title like 'An equation of state {\e= %'; >=20 > I noticed you escaped the % in the first query, but not the second. No > idea how that effects things. Well, the "\" is part of the strings to be outputed, so I did not intend to quota anything. If I replace \ to \\ in my first query, I get also no result. Greetings Helge --=20 Helge Kreutzmann, Dipl.-Phys. Helge.Kreutzmann@itp.uni-hannov= er.de gpg signed mail preferred gpg-key: finger kreutzm@rigel.itp.uni-hannov= er.de 64bit GNU powered http://www.itp.uni-hannover.de/~kreu= tzm Help keep free software "libre": http://www.freepatents.org/ --t4apE7yKrX2dGgJC Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8yCdd8gjPnR7H0q0RAqusAJ4rrE4rzvJdU6YnHRlJhlkk2Mw3DACfcNo9 JuVb4FpIjUTgUa1IxL2Kaek= =tXDa -----END PGP SIGNATURE----- --t4apE7yKrX2dGgJC--