Timeline for Postgis query to sort geometries by latitude
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 27, 2016 at 1:03 | comment | added | Mike T |
PostgreSQL calls this an implicit cast, where the type is automatically converted to match another type used by the function. You can see that the geometry->box2d cast is marked IMPLICIT to enable this handy feature.
|
|
| Apr 26, 2016 at 15:19 | history | edited | a1an | CC BY-SA 3.0 |
removed conversion and reversed sort order
|
| Apr 26, 2016 at 15:17 | comment | added | a1an | You are right, I did not notice it does not require converting the geometry. Then I guess it is exactly the operator I am looking for to sort results. | |
| Apr 26, 2016 at 13:34 | comment | added | user30184 |
You can use ST_YMax directly without building Box2D ST_YMax(geom) from table
|
|
| Apr 26, 2016 at 13:28 | history | answered | a1an | CC BY-SA 3.0 |