On 18/11/24 15:43, Gianni Ceccarelli wrote:
> On Mon, 18 Nov 2024 15:37:57 +0100
> Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)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
>
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