Re: [GENERAL] Escaping underscores in LIKE

[Tom Lane]

[EMAIL PROTECTED] writes:
> Am I doing something stupid trying to escape an underscore in LIKE?

You need more backslashes.  Don't forget the string-literal parser eats
one level of backslashes, before LIKE ever gets to see the pattern.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html