"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