Re: Proper quoting of \e ?

From: Helge Kreutzmann <kreutzm(at)itp(dot)uni-hannover(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Proper quoting of \e ?
Date: 2002-04-25 15:57:18
Message-ID: 20020425175718.B31354@itp.uni-hannover.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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/

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Joe Conway 2002-04-25 16:23:01 Re: Proper quoting of \e ?
Previous Message Bruce Momjian 2002-04-25 15:47:16 Re: Proper quoting of \e ?