[Django] #28928: Support expression indexes for GinIndex

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[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.

--
You received this message because you are subscribed to the Google Groups "Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/052.4baa50c6a8eca9ba73d54e14adb2bf2f%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: [Django] #28928: Add support for expression indexes for GinIndex (was: Support expression indexes for GinIndex)

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 <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

--
You received this message because you are subscribed to the Google Groups "Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/067.49be55c0267a0d405c83cf14d3fd4561%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: [Django] #28928: Add support for expression indexes for GinIndex

Django
In reply to this post by 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 <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

--
You received this message because you are subscribed to the Google Groups "Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/067.21a30a6da5c259af7bce524e1a6a370e%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: [Django] #28928: Add support for expression indexes for GinIndex

Django
In reply to this post by 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 <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

--
You received this message because you are subscribed to the Google Groups "Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/067.bca1e05566c25386708d35235c03c715%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: [Django] #28928: Add support for expression indexes for GinIndex

Django
In reply to this post by 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 <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

--
You received this message because you are subscribed to the Google Groups "Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/067.6454dcf4dddf35bf91b09c14029a6547%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.