Opened 50 minutes ago
#37420 new Uncategorized
GIS ST_MakeLine, ST_Union and ST_Collect should accept the ORDER BY clause
| Reported by: | Jefferson Raylan | Owned by: | |
|---|---|---|---|
| Component: | GIS | Version: | 6.1 |
| Severity: | Normal | Keywords: | |
| Cc: | Jefferson Raylan | Triage Stage: | Unreviewed |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
Since PostGIS version 2.2, ST_MakeLine, ST_Union, and ST_Collect accept the ORDER BY clause when running on PostgreSQL version 9+. However, Django still does not support it. It would be nice to have this feature integrated. Since Django currently requires PostgreSQL version 15+ and PostGIS version 3.2, backward compatibility so it should not be an issue
Postgres 9.0.0 release note:
https://www.postgresql.org/docs/release/9.0.0/#AEN103013
PostGIS 2.2 ST_MakeLine manual:
https://postgis.net/docs/manual-2.2/ST_MakeLine.html#idm4835
Django 6.1 release note about PostgreSQL version:
https://docs.djangoproject.com/en/6.1/releases/6.1/#dropped-support-for-postgresql-14
Django 6.1 release note about PostGIS version:
https://docs.djangoproject.com/en/6.1/releases/6.1/#id3