On 20 Oct 2016, at 23:37, Maxim Boguk <maxim.bo...@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 respective character 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
