Postgres Pro
Downloads
Home   >   mailing lists

Re: Index only scans for expressional indices when querying for the expression - Mailing list pgsql-general

From David G. Johnston
Subject Re: Index only scans for expressional indices when querying for the expression
Date
Msg-id CAKFQuwZTD0NydFg8Ra4kUuU2WDxY53FCx9Zh6_OwVjdCLThp8w@mail.gmail.com
Whole thread Raw
In response to Index only scans for expressional indices when querying for the expression  (Danny Shemesh <dany74q@gmail.com>)
Responses Re: Index only scans for expressional indices when querying for the expression
List pgsql-general
Tree view
On Thursday, August 4, 2022, Danny Shemesh <dany74q@gmail.com> wrote:
I believe the expressional index in itself could've been considered as covering, when querying for the expression explicitly.

This belief is wrong.  When storing f(x) there is no way to recover the value of x.

David J.
 

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: Behavior of identity columns
Next
From: Danny Shemesh
Date:
Subject: Re: Index only scans for expressional indices when querying for the expression