Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgres: Support creating functional indexes #756

Open
gitmalong opened this issue Feb 21, 2024 · 1 comment
Open

Postgres: Support creating functional indexes #756

gitmalong opened this issue Feb 21, 2024 · 1 comment

Comments

@gitmalong
Copy link

gitmalong commented Feb 21, 2024

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

@gitmalong gitmalong changed the title Support creating functional indexes Postgres: Support creating functional indexes Feb 21, 2024
@ap32
Copy link

ap32 commented Mar 28, 2024

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants