Received: from mgate2.uni-hannover.de (mgate2.uni-hannover.de [130.75.2.5]) by postgresql.org (Postfix) with ESMTP id 7DE94475862 for ; Thu, 25 Apr 2002 06:24:08 -0400 (EDT) Received: from wega.itp.uni-hannover.de by mgate2.uni-hannover.de with LocalSMTP (PP) with ESMTP; Thu, 25 Apr 2002 12:22:54 +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 MAA12598 for ; Thu, 25 Apr 2002 12:22:53 +0200 Received: (from kreutzm@localhost) by mirzam.itp.uni-hannover.de (8.11.6/8.9.3) id g3PAMr829165 for pgsql-sql@postgresql.org; Thu, 25 Apr 2002 12:22:53 +0200 Date: Thu, 25 Apr 2002 12:22:53 +0200 From: Helge Kreutzmann To: pgsql-sql@postgresql.org Subject: Proper quoting of \e ? Message-ID: <20020425122253.A29150@itp.uni-hannover.de> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-md5; protocol="application/pgp-signature"; boundary="Dxnq1zWXvFF0Q93v" Content-Disposition: inline User-Agent: Mutt/1.2.5i 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/298 X-Sequence-Number: 7562 --Dxnq1zWXvFF0Q93v Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hello ! We have a database in SQL_ASCII in postgres 7.2.1 which contains among other information document titles which are automatically retrieved. 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): 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-dimensional = fluid of hard hyperspheres (1 row) works, but if I take one character more (or, later, the entire title), it does not: SELECT title from written_by where title like 'An equation of state {\e%'; title=20 ------- (0 rows) I tried various variations (like \\e and simmilar) and looked through the interactive docs but did not find anything. Unfortunately I could not search through the list archives because of some problems with the backend database. Thanks for any pointers 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/ --=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/ --Dxnq1zWXvFF0Q93v 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 iD8DBQE8x9j98gjPnR7H0q0RAoXeAJsFn879RpPu+Ka1GumiKWCaSDA/DQCfc7/I 9oNZcfiTACeNIBYtEE3Hni8= =WLnM -----END PGP SIGNATURE----- --Dxnq1zWXvFF0Q93v--