Re: ^@ operator for text

[Олег Самойлов]

> 23 дек. 2021 г., в 18:18, Tom Lane  написал(а):
> 
> PG Doc comments form  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-GIST index. So searching and 
filtering can be indexed.

Re: ^@ operator for text

[Tom Lane]

=?utf-8?B?0J7Qu9C10LMg0KHQsNC80L7QudC70L7Qsg==?=  writes:
> 23 дек. 2021 г., в 18:18, Tom Lane  написал(а):
>> 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