Michael Brusser <michael(at)synchronicity(dot)com> writes:
> But when I doubled the number of backslashes:
>   SELECT smth. FROM  tbl WHERE situation LIKE '%\\\\%';
> - it actually worked fine.

Backslash is special to both the string-literal parser and the LIKE code.
So when you write the above, the pattern value that arrives at the LIKE
processor has one less level of backslashing:
	%\\%
and the LIKE processor interprets this as percent, a literal backslash,
and another percent.

			regards, tom lane

In response to

• Using backslash in query at 2003-10-03 13:40:50 from Michael Brusser

Responses

• Re: Using backslash in query at 2003-10-04 08:20:09 from Hannu Krosing

pgsql-hackers by date

Next:	From: Rod Taylor	Date: 2003-10-03 15:35:28
	Subject: Re: Oracle/PostgreSQL incompatibilities
Previous:	From: scott.marlowe	Date: 2003-10-03 15:24:18
	Subject: Re: Question regarding coopting Database Engine