"Her Goo" <[EMAIL PROTECTED]> writes: > I want to go a step further, and restrict the results to those > that begin with string "abc\d".
You need four backslashes for that, because \ is special to both
the string literal parser and the LIKE operator. So '\\\\'
reduces to a string constant containing \\, and then the LIKE
operator sees that as a quoted backslash.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
