vojta(dot)rylko(at)gmail(dot)com writes:
> Hi, LIKE behaves differently depending on left side.
>> select 1 where '\' like '\\\'; -- one and three backslashes
> ?column?
> ----------
> (0 rows)
>> select 1 where '\\' like '\\\'; -- two and three backslashes
> ERROR: LIKE pattern must not end with escape character
I see no bug here. The pattern is wrong, but it happens not to notice in
the first case because it never reaches the buggy part of the pattern.
regards, tom lane