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-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/

Browse pgsql-sql by date

  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!