[Django] #28928: Support expression indexes for GinIndex

[Django]

#28928: Support expression indexes for GinIndex
--------------------------------------------+------------------------
Reporter: James Howe | Owner: (none)
Type: New feature | Status: new
Component: contrib.postgres | Version: 1.11
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
--------------------------------------------+------------------------
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));
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/28928>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#28928: Add support for expression indexes for GinIndex
----------------------------------+------------------------------------

Reporter: James Howe | Owner: (none)
Type: New feature | Status: new
Component: contrib.postgres | Version: 1.11

Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0

----------------------------------+------------------------------------
Changes (by Tim Graham):

* stage: Unreviewed => Accepted

--
Ticket URL: <https://code.djangoproject.com/ticket/28928#comment:1>

[Django]

#28928: Add support for expression indexes for GinIndex
----------------------------------+------------------------------------

Reporter: James Howe | Owner: (none)
Type: New feature | Status: new
Component: contrib.postgres | Version: 1.11

Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0

----------------------------------+------------------------------------
Description changed by James Howe:

Old description:

> 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));
> }}}

New description:

I'm envisaging an api such that
{{{
GinIndex(fields=['jdoc.tags[0]'])
}}}
would generate
{{{

CREATE INDEX jdoc_gin ON mymodel USING GIN (((jdoc -> 'tags')::jsonb ->
0));
}}}

--

--
Ticket URL: <https://code.djangoproject.com/ticket/28928#comment:2>

[Django]

#28928: Add support for expression indexes for GinIndex
----------------------------------+------------------------------------

Reporter: James Howe | Owner: (none)
Type: New feature | Status: new
Component: contrib.postgres | Version: 1.11

Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0

----------------------------------+------------------------------------
Description changed by James Howe:

Old description:

> I'm envisaging an api such that

> {{{
> GinIndex(fields=['jdoc.tags[0]'])
> }}}
> would generate
> {{{

> CREATE INDEX jdoc_gin ON mymodel USING GIN (((jdoc -> 'tags')::jsonb ->
> 0));
> }}}

New description:

I'm envisaging an api such that
{{{
GinIndex(fields=['jdoc.tags[0]'])
}}}
would generate
{{{

CREATE INDEX jdoc_gin ON mymodel USING GIN (((jdoc->>'tags')::jsonb->>0));
}}}

--

--
Ticket URL: <https://code.djangoproject.com/ticket/28928#comment:3>

[Django]

#28928: Add support for expression indexes for GinIndex
----------------------------------+------------------------------------

Reporter: James Howe | Owner: (none)
Type: New feature | Status: new
Component: contrib.postgres | Version: 1.11

Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0

----------------------------------+------------------------------------
Description changed by James Howe:

Old description:

> I'm envisaging an api such that

> {{{
> GinIndex(fields=['jdoc.tags[0]'])
> }}}
> would generate
> {{{
> CREATE INDEX jdoc_gin ON mymodel USING GIN

> (((jdoc->>'tags')::jsonb->>0));
> }}}

New description:

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));
}}}

--

--
Ticket URL: <https://code.djangoproject.com/ticket/28928#comment:4>

[Django]

#28928: Add support for expression indexes for GinIndex
----------------------------------+------------------------------------

Reporter: James Howe | Owner: (none)
Type: New feature | Status: new
Component: contrib.postgres | Version: 1.11

Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0

----------------------------------+------------------------------------

Comment (by Claude Paroz):

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?

--
Ticket URL: <https://code.djangoproject.com/ticket/28928#comment:5>

[Django]

#28928: Add support for expression indexes for GinIndex

----------------------------------+-------------------------------------

Reporter: James Howe | Owner: (none)

Type: New feature | Status: closed
Component: contrib.postgres | Version: 1.11
Severity: Normal | Resolution: duplicate
Keywords: | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0

----------------------------------+-------------------------------------
Changes (by Hannes Ljungberg):

* status: new => closed
* resolution: => duplicate

Comment:

Duplicate of [https://code.djangoproject.com/ticket/26167 #26167].

--
Ticket URL: <https://code.djangoproject.com/ticket/28928#comment:6>