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

help / color / mirror / Atom feed

From: Euler Taveira <euler@eulerto.com>
To: pgsql-docs@lists.postgresql.org
Subject: Re: An inconsistency in the documentation about full text search
Date: Wed, 29 Nov 2023 15:39:07 -0300
Message-ID: <3e2a2d49-1241-4c48-90df-63f11d4bd45c@app.fastmail.com> (raw)
In-Reply-To: <AM9PR01MB826802130AD5EEC6BBF5FC9AFEA9A@AM9PR01MB8268.eurprd01.prod.exchangelabs.com>
References: <AM9PR01MB826802130AD5EEC6BBF5FC9AFEA9A@AM9PR01MB8268.eurprd01.prod.exchangelabs.com>

On Tue, Nov 7, 2023, at 7:12 AM, Erki Eessaar wrote:
> Section
> 
> 12.2.2. Creating Indexes
> https://www.postgresql.org/docs/current/textsearch-tables.html#TEXTSEARCH-TABLES-INDEX
> 
> wrtites the following: "Another approach is to create a separate tsvector column to hold the output of to_tsvector. To keep this column automatically up to date with its source data, use a stored generated column. This example is a concatenation of title and body, using coalesce to ensure that one field will still be indexed when the other is NULL"
> 
> Section
> 
> 12.4.3. Triggers for Automatic Updates
> https://www.postgresql.org/docs/current/textsearch-features.html#TEXTSEARCH-UPDATE-TRIGGERS

This section has a note at the top that this trigger-based method is obsolete
and refers to section 12.2.2 (Creating Indexes).


--
Euler Taveira
EDB   https://www.enterprisedb.com/

view thread (2+ messages)

Message-ID: <3e2a2d49-1241-4c48-90df-63f11d4bd45c@app.fastmail.com>
Permalink:  ../3e2a2d49-1241-4c48-90df-63f11d4bd45c@app.fastmail.com/
Also on:    postgresql.org/message-id/3e2a2d49-1241-4c48-90df-63f11d4bd45c@app.fastmail.com

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: euler@eulerto.com, pgsql-docs@lists.postgresql.org
  Subject: Re: An inconsistency in the documentation about full text search
  In-Reply-To: <3e2a2d49-1241-4c48-90df-63f11d4bd45c@app.fastmail.com>

* 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