"Her Goo" <gu_he@msn.com> 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