| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Олег Самойлов <splarv(at)ya(dot)ru> |
| Cc: | Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: ^@ operator for text |
| Date: | 2021-12-24 22:56:12 |
| Message-ID: | 1125955.1640386572@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
=?utf-8?B?0J7Qu9C10LMg0KHQsNC80L7QudC70L7Qsg==?= <splarv(at)ya(dot)ru> writes:
> 23 дек. 2021 г., в 18:18, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> написал(а):
>> I did do something about this recently, though:
>> https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=2ae5d72f0
> I think need to mention that the main benefits of this operator (vs function starts_with) is the using with special SP-GIST index. So searching and filtering can be indexed.
Not really true anymore, see a148f8bc0.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erki Eessaar | 2021-12-25 14:36:27 | SQL-standard function bodies and creating SECURITY DEFINER routines securely |
| Previous Message | Олег Самойлов | 2021-12-24 11:52:56 | Re: ^@ operator for text |