Michael Brusser <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])