#34255: Annotation/group by with an expression on psycopg3
-------------------------------------+-------------------------------------
     Reporter:  Guillaume Andreu     |                    Owner:  nobody
  Sabater                            |
         Type:  Bug                  |                   Status:  new
    Component:  Database layer       |                  Version:  dev
  (models, ORM)                      |
     Severity:  Release blocker      |               Resolution:
     Keywords:  orm postgres         |             Triage Stage:  Accepted
  psycopg3 annotation groupby        |
    Has patch:  0                    |      Needs documentation:  0
  Needs tests:  0                    |  Patch needs improvement:  0
Easy pickings:  0                    |                    UI/UX:  0
-------------------------------------+-------------------------------------

Comment (by Simon Charette):

 I believe here the issue is that the `year` annotation is ''elided'' from
 the query for a good reason, only one column must be present in the
 `ARRAY`/`SubqueryArray` construct.

 In other words, the problem is not about grouping by alias or column index
 but grouping by an expression that is elided from the select clause and
 thus cannot be grouped by reference.

-- 
Ticket URL: <https://code.djangoproject.com/ticket/34255#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 [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/01070185a9668c7d-a01936b1-c880-4bf8-9f90-cd482d958e09-000000%40eu-central-1.amazonses.com.

Reply via email to