On 20 Oct 2016, at 23:37, Maxim Boguk <maxim.boguk@gmail.com> wrote:
> Underscore in like pattern have a special meaning of "any symbol".
> From documentation on the https://www.postgresql.org/docs/9.4/static/functions-matching.html :
> "An underscore (_) in pattern stands for (matches) any single character;"
> This could be useful as well: "To match a literal underscore or percent sign without matching other characters, the
respectivecharacter in pattern must be preceded by the escape character.”
Oops, how embarrassing. For some reason I thought PostgreSQL only had "%". Thanks for clearing that up.
