> 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.
pgsql-docs by date:
Соглашаюсь с условиями обработки персональных данных