Proper quoting of \e ?

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-25 10:22:53
Message-ID: 20020425122253.A29150@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/
--
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/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message bob lapique 2002-04-25 12:27:00 Re: How to discover foreign keys (without pulling hair out)
Previous Message Morten Sickel 2002-04-25 09:32:40 HAVING - clause