Re: [SQL] inconsistent functionality with LIKE operator

Phuong Ma <pma(at)commandprompt(dot)com> writes:
> I'm using PostgreSQL version 7.1, and I'm having trouble with the LIKE
> statement. How would I find the value "a\bc"? I tried using the
> backslash to escape it: LIKE 'a\\b%';

I think you need four backslashes. The string-literal parser eats one
level of backslashes, but you need the pattern that arrives at LIKE
to look like "a\\b%".

BTW, "PostgreSQL version 7.1" does not exist yet.

regards, tom lane