Re: Proper quoting of \e ? - Mailing list pgsql-sql

From Helge Kreutzmann
Subject Re: Proper quoting of \e ?
Date
Msg-id 20020425175718.B31354@itp.uni-hannover.de
Whole thread Raw
In response to Re: Proper quoting of \e ?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
On Thu, Apr 25, 2002 at 11:47:16AM -0400, Bruce Momjian wrote:
> > 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%';
>
> I noticed you escaped the % in the first query, but not the second.  No
> idea how that effects things.

Well, the "\" is part of the strings to be outputed, so I did not
intend to quota anything. If I replace \ to \\ in my first query, I
get also no result.

Greetings
         Helge
--
Helge Kreutzmann, Dipl.-Phys.               Helge.Kreutzmann@itp.uni-hannover.de gpg signed mail preferred    gpg-key:
fingerkreutzm@rigel.itp.uni-hannover.de   64bit GNU powered                  http://www.itp.uni-hannover.de/~kreutzm
 Help keep free software "libre": http://www.freepatents.org/ 

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Proper quoting of \e ?
Next
From: Joe Conway
Date:
Subject: Re: Proper quoting of \e ?