Received: from mimosa.itp.uni-hannover.de (mimosa.itp.uni-hannover.de [130.75.25.103]) by postgresql.org (Postfix) with ESMTP id 9AD1F47589A for ; Wed, 24 Apr 2002 09:12:11 -0400 (EDT) Received: (from kreutzm@localhost) by mimosa.itp.uni-hannover.de (8.11.6/8.11.6) id g3ODCES08574 for pgsql-sql@postgresql.org; Wed, 24 Apr 2002 15:12:14 +0200 Date: Wed, 24 Apr 2002 15:12:14 +0200 From: Helge Kreutzmann To: pgsql-sql@postgresql.org Subject: Proper quoting of \e Message-ID: <20020424151214.A8561@itp.uni-hannover.de> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-md5; protocol="application/pgp-signature"; boundary="x+6KMIRAuhnl3hBn" 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/302 X-Sequence-Number: 7566 --x+6KMIRAuhnl3hBn 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/ --x+6KMIRAuhnl3hBn 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 iD8DBQE8xq8t8gjPnR7H0q0RAg0hAKCCkM6/qMQAMZM0d6W7JSMuTph7lACfbJAv yGg4g3to75evLR2BJ9YHy/E= =CDp1 -----END PGP SIGNATURE----- --x+6KMIRAuhnl3hBn--