#36690: Use case for EXTRA()
--------------------------------+--------------------------------------
     Reporter:  Gareth Leake    |                    Owner:  (none)
         Type:  Uncategorized   |                   Status:  new
    Component:  Uncategorized   |                  Version:  5.2
     Severity:  Normal          |               Resolution:
     Keywords:  QuerySet.extra  |             Triage Stage:  Unreviewed
    Has patch:  0               |      Needs documentation:  0
  Needs tests:  0               |  Patch needs improvement:  0
Easy pickings:  0               |                    UI/UX:  0
--------------------------------+--------------------------------------
Changes (by ontowhee):

 * keywords:   => QuerySet.extra

Comment:

 I found ticket #3575, which reported that using `ILIKE` in postgres is
 inefficient, and the solution changed the SQL from using `ILIKE` to
 `UPPER`. Since `extra()` is planned for deprecation, could the query be
 achieved by implementing a `Func` for `ILIKE` instead?
-- 
Ticket URL: <https://code.djangoproject.com/ticket/36690#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 [email protected].
To view this discussion visit 
https://groups.google.com/d/msgid/django-updates/0107019a27c3524e-a02f8cc2-a0dd-4fb8-a8e9-aa417bcff1ab-000000%40eu-central-1.amazonses.com.

Reply via email to