pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Олег Самойлов <splarv@ya.ru>
Cc: Pg Docs <pgsql-docs@lists.postgresql.org>
Subject: Re: ^@ operator for text
Date: Fri, 24 Dec 2021 17:56:12 -0500
Message-ID: <1125955.1640386572@sss.pgh.pa.us> (raw)
In-Reply-To: <10BC6099-7829-469A-BF19-0928B0DD5E35@ya.ru>
References: <164025929698.19324.7276266494030468977@wrigleys.postgresql.org>
	<528689.1640272714@sss.pgh.pa.us>
	<10BC6099-7829-469A-BF19-0928B0DD5E35@ya.ru>

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

view thread (4+ messages)

Message-ID: <1125955.1640386572@sss.pgh.pa.us>
Permalink:  ../1125955.1640386572@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1125955.1640386572@sss.pgh.pa.us

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, splarv@ya.ru, pgsql-docs@lists.postgresql.org
  Subject: Re: ^@ operator for text
  In-Reply-To: <1125955.1640386572@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox