On 18/11/24 15:43, Gianni Ceccarelli wrote:
On Mon, 18 Nov 2024 15:37:57 +0100
Moreno Andreo <moreno.andreo@xxxxxxxxxx> 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
Hi Gianni,
correct. That's a good starting point (now I have to add complexity
since the index should have 4 columns, one of them is referenced with LIKE)
Thanks!
Moreno
