Re: Proper quoting of \e ?

Helge Kreutzmann wrote:
> 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.
>

I think you need 4 '\'s:

test=# create table written_by(title text);
CREATE
test=# insert into written_by values('An equation of state {\\em \\\`a
la} Carnahan-Starling');
INSERT 16661 1
test=# select * from written_by;
title
-----------------------------------------------------
An equation of state {\em \`a la} Carnahan-Starling
(1 row)

test=# SELECT title from written_by where title like 'An equation of
state {\\\\e%';
title
-----------------------------------------------------
An equation of state {\em \`a la} Carnahan-Starling
(1 row)

This is because the string literal parser reduces '\\\\' to '\\', and
then the backend function which implements LIKE interprets '\\' as '\'.

HTH,

Joe