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