[GENERAL] Re: [SQL] inconsistent functionality with LIKE operator

2001-03-29 Thread Tom Lane
Phuong Ma <[EMAIL PROTECTED]> 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 o

[SQL] inconsistent functionality with LIKE operator

2001-03-29 Thread Phuong Ma
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%'; If I specify: LIKE 'a\\bc', then it works, but if I wanted it to look for consecetive characters after the c, using the %,