On 20 Oct 2016, at 23:37, Maxim Boguk <maxim.boguk@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
