Motivation

Create functional indexes

for example, a common way to do case-insensitive comparisons is to use the lower function:

SELECT * FROM test1 WHERE lower(col1) = 'value';
This query can use an index, if one has been defined on the result of the lower(column) operation:

CREATE INDEX test1_lower_col1_idx ON test1 (lower(col1));

Source: https://www.postgresql.org/docs/7.3/indexes-functional.html

Proposed Solutions

Additional Information