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