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)
44973863@qq.com
