| From: | Alexander Staubo <alex(at)purefiction(dot)net> |
|---|---|
| To: | Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: text_pattern_ops index not being used for prefix query |
| Date: | 2016-10-21 04:11:01 |
| Message-ID: | 2172C7ED-714D-4BA5-A584-3F04E7498E90@purefiction.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 20 Oct 2016, at 23:37, Maxim Boguk <maxim(dot)boguk(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andre Mikulec | 2016-10-21 05:37:40 | Re: configure PostgreSQL with PERL: Perl version 5.8 or later is required, but this is . |
| Previous Message | Maxim Boguk | 2016-10-21 03:37:14 | Re: text_pattern_ops index not being used for prefix query |