#23753: Provide a set of SQL functions
----------------------------------------------+-------------------------
Reporter: jarshwah | Owner: nobody
Type: New feature | Status: new
Component: Database layer (models, ORM) | Version: master
Severity: Normal | Keywords: expressions
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
----------------------------------------------+-------------------------
When #14030 lands there will be an easy way to implement SQL functions
like LENGTH() and COALESCE(). There are several tickets requesting the
implementation of certain functions, and this ticket aims to collate those
requests, and extend the number of functions to a useable minimum subset.
There was a discussion on the mailing list that calls out some
implementation details as well as the set of functions to implement:
https://groups.google.com/forum/?utm_medium=email&utm_source=footer#!msg
/django-developers/HggiPzwkono/SgXt4iNjTIYJ
List of functions:
- Coalesce
- ToLower/Lower
- ToUpper/Upper
- Length
- Case-When / IIF
- Substring
This list isn't necessarily complete or final. If there are other
functions that you'd like to see implemented in core, please comment, and
I'll update the list above. Particular implementation details can be
discussed on the PR or below once a PR is submitted. I'll aim to have
these completed very soon after #14030 lands, and I expect these to be
available in the same django version that incorporates 14030.
Linked tickets:
- #23363 (Length)
- #21208 (Coalesce in .extra)
- #10929 (Coalesce for Aggregates - could also be done by customising the
aggregate directly)
--
Ticket URL: <https://code.djangoproject.com/ticket/23753>
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 post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/051.157604a321c1c4e6a2499d92b85bc2d2%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
