Hi everyone, Thanks a lot for all the patches, tests and insightful discussions so far.
From the current status, PostgreSQL already permits creating indexes with whole-row references. However, there exists inconsistent handling between such indexes and the query planner during runtime. As a result, these indexes cannot work as expected, including failures in index scan, index-only scan and partial predicate matching. Given this situation, I intend to improve the related logic to provide better index support for both whole-row references and virtual generated columns. Therefore, I am sending this proposal: Support virtual generated columns in index expressions and predicates. regards, -- ZizhuanLiu (X-MAN) [email protected]
