From: Gianni Ceccarelli <dakkar@thenautilus.net>
To: pgsql-general@lists.postgresql.org
Subject: Re: Functions and Indexes
Date: Mon, 18 Nov 2024 14:43:07 +0000
Message-ID: <20241118144307.2017e712@exelion> (raw)
In-Reply-To: <8dfd0bd5-87e5-4de7-9f60-8a680a32bc11@evolu-s.it>
References: <2e36a2fe-b30f-46a5-937f-3b7d94e75cb6@evolu-s.it>
<8dfd0bd5-87e5-4de7-9f60-8a680a32bc11@evolu-s.it>
On Mon, 18 Nov 2024 15:37:57 +0100
Moreno Andreo <moreno.andreo@evolu-s.it> wrote:
> If a column appears in the WHERE clause (and so it should be placed
> in index), in case it is "processed" in a function (see below), is it
> possible to insert this function to further narrow down things?
You probably want to look at
https://www.postgresql.org/docs/current/indexes-expressional.html
--
Dakkar - <Mobilis in mobile>
GPG public key fingerprint = A071 E618 DD2C 5901 9574
6FE2 40EA 9883 7519 3F88
key id = 0x75193F88
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-general@postgresql.org
Cc: dakkar@thenautilus.net, pgsql-general@lists.postgresql.org
Subject: Re: Functions and Indexes
In-Reply-To: <20241118144307.2017e712@exelion>
* 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