>
> > hi.
> > refactor and rebase.
>
> fix the regress tests failure in v4.
>

This may need another rebase, as it doesn't apply to master.

I'm interested in this feature, specifically whether the optimizer uses the
index in situations where the expression is used rather than the virtual
column name.

For example:

CREATE TABLE example (
   regular_name text,
   lowecase_name text GENERATED ALWAYS AS lower(regular_name) VIRTUAL
);

CREATE INDEX example_b ON example(b);

EXPLAIN SELECT regular_name FROM example WHERE lowercase_name = 'john q
smith';

EXPLAIN SELECT regular_name FROM example WHERE lower(regular_name) = 'john
q smith';

Reply via email to