Re: ^@ operator for text

> 23 дек. 2021 г., в 18:18, Tom Lane <tgl@sss.pgh.pa.us> написал(а):
>
> PG Doc comments form <noreply@postgresql.org> writes:
>> In the new documentation
>> https://www.postgresql.org/docs/14/functions-string.html
>> you again lost information about ^@ operator for text and keep information
>> about only function starts_with on which this operator is based.
>
> "Again"?  It was never there before, cf
>
> https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=710d90da1
>
> I did do something about this recently, though:
>
> https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=2ae5d72f0
>
>             regards, tom lane


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.