prefix match operator ^@

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: splarv(at)ya(dot)ru
Subject: prefix match operator ^@
Date: 2020-04-20 16:56:00
Message-ID: 158740176041.11601.7844237687908212295@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/functions-string.html
Description:

Preparing to upgrade old PostgreSQL and looking changelog, I has found log
about "prefix text match" operator (boosted by SP_GIST):
=> select 'ab' ^@ 'a';
?column?
----------
t
(1 row)

Yes, search on prefix is widely used, indeed. But there is nothing about it
in the documentation. Instead exists only a function "starts_with", may be
this is a different thing. And may be it is not boosted by the index in the
same way, as operator ^(at)(dot) And functionality is duplicated.

At least this operator must be documented.

Browse pgsql-docs by date

  From Date Subject
Next Message Alvaro Herrera 2020-04-20 17:47:03 Re: Documentation issue: Default value of temp_buffers
Previous Message PG Doc comments form 2020-04-20 13:11:25 Documentation issue: Default value of temp_buffers