From: | Helge Kreutzmann <kreutzm(at)itp(dot)uni-hannover(dot)de> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Proper quoting of \e |
Date: | 2002-04-24 13:12:14 |
Message-ID: | 20020424151214.A8561@itp.uni-hannover.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
-------
(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
--
Helge Kreutzmann, Dipl.-Phys. Helge(dot)Kreutzmann(at)itp(dot)uni-hannover(dot)de
gpg signed mail preferred gpg-key: finger kreutzm(at)rigel(dot)itp(dot)uni-hannover(dot)de
64bit GNU powered http://www.itp.uni-hannover.de/~kreutzm
Help keep free software "libre": http://www.freepatents.org/
From | Date | Subject | |
---|---|---|---|
Next Message | Bullock, Dempsey | 2002-04-24 14:04:48 | BLOB Feature Limits |
Previous Message | Rajesh Kumar Mallah | 2002-04-24 05:57:23 | Re: Cannot get to use index scan on a big table! |