Re: ^@ operator for text - Mailing list pgsql-docs

From Tom Lane
Subject Re: ^@ operator for text
Date
Msg-id 1125955.1640386572@sss.pgh.pa.us
Whole thread Raw
In response to Re: ^@ operator for text  (Олег Самойлов <splarv@ya.ru>)
List pgsql-docs
=?utf-8?B?0J7Qu9C10LMg0KHQsNC80L7QudC70L7Qsg==?= <splarv@ya.ru> writes:
> 23 дек. 2021 г., в 18:18, Tom Lane <tgl@sss.pgh.pa.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-GISTindex. So searching and filtering can be indexed. 

Not really true anymore, see a148f8bc0.

            regards, tom lane



pgsql-docs by date:

Previous
From: Олег Самойлов
Date:
Subject: Re: ^@ operator for text
Next
From: Erki Eessaar
Date:
Subject: SQL-standard function bodies and creating SECURITY DEFINER routines securely