#32346: Expose ROW_NUMBER functionality.
-------------------------------------+-------------------------------------
               Reporter:  Stuart     |          Owner:  nobody
  Axon                               |
                   Type:  New        |         Status:  new
  feature                            |
              Component:  Database   |        Version:  3.1
  layer (models, ORM)                |       Keywords:  row_number,
               Severity:  Normal     |  iterator
           Triage Stage:             |      Has patch:  0
  Unreviewed                         |
    Needs documentation:  0          |    Needs tests:  0
Patch needs improvement:  0          |  Easy pickings:  0
                  UI/UX:  0          |
-------------------------------------+-------------------------------------
 ROW_NUMBER opens up possibilities for users to optimise queries.

 It is supported in all the major databases:

 Oracle: ROW_NUMBER
 Postgres: ROW_NUMBER
 MYSQL:  ROW_NUMBER since 8.0
 Sqlite: ROW_NUMBER since 3.25.0
 MSSQL:  ROW_NUMBER all supported versions

 Supporting it would help in use cases where the user is building records
 that currently use python enumerate.

 I'm not sure what a django-esque name would be, there are probably better
 ones than row_number.

-- 
Ticket URL: <https://code.djangoproject.com/ticket/32346>
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/049.e1296cbd94f29a2cbe54f60c6fded640%40djangoproject.com.

Reply via email to