Opened 7 years ago
Closed 4 years ago
#28928 closed New feature (duplicate)
Add support for expression indexes for GinIndex
| Reported by: | James Howe | Owned by: | |
|---|---|---|---|
| Component: | contrib.postgres | Version: | 1.11 |
| Severity: | Normal | Keywords: | |
| Cc: | Triage Stage: | Accepted | |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description (last modified by )
I'm envisaging an api such that
GinIndex(fields=['jdoc.tags[0]'])
would generate
CREATE INDEX jdoc_gin ON mymodel USING GIN ((jdoc -> 'tags' -> 0));
Change History (6)
comment:1 by , 7 years ago
| Summary: | Support expression indexes for GinIndex → Add support for expression indexes for GinIndex |
|---|---|
| Triage Stage: | Unreviewed → Accepted |
comment:2 by , 7 years ago
| Description: | modified (diff) |
|---|
comment:3 by , 7 years ago
| Description: | modified (diff) |
|---|
comment:4 by , 7 years ago
| Description: | modified (diff) |
|---|
comment:5 by , 5 years ago
Note:
See TracTickets
for help on using tickets.
I guess that creating an index like:
CREATE INDEX pgweb_idx ON pgweb USING GIN (to_tsvector('english', body));is another use case for this ticket?