Re: ^@ operator for text

> 23 дек. 2021 г., в 18:18, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> написал(а):
>
> PG Doc comments form <noreply(at)postgresql(dot)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.