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 James Howe)

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 Tim Graham, 7 years ago

Summary: Support expression indexes for GinIndex → Add support for expression indexes for GinIndex
Triage Stage: Unreviewed → Accepted

comment:2 by James Howe, 7 years ago

Description: modified (diff)

comment:3 by James Howe, 7 years ago

Description: modified (diff)

comment:4 by James Howe, 7 years ago

Description: modified (diff)

comment:5 by Claude Paroz, 6 years ago

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?

comment:6 by Hannes Ljungberg, 4 years ago

Resolution: → duplicate
Status: new → closed

Duplicate of #26167.

Note: See TracTickets for help on using tickets.
Back to Top