=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
> PostgreSQL will not always detect an invalid LIKE pattern (one that ends
> with a backslash).
> This probably happens because the pattern is only parsed lazily (as needed);
> if PostgreSQL detects that a match is impossible, it doesn't even look at
> the rest of the pattern.
Yeah, exactly.
> Still, it would be nice for error reporting to be consistent.
This has been discussed before, but nobody could see how to do it without
taking a performance hit (ie, doing a full scan of the pattern before
doing any actual work). It didn't seem worth that.
It occurs to me that we could make the behavior more consistent by
redefining a trailing backslash as something we silently ignore, instead
of raising an error. Not sure if that's an improvement, though.
regards, tom lane