[postgis-tickets] [PostGIS] #3672: Change aggregate functions to use new syntax

PostGIS trac at osgeo.org
Sat Nov 26 11:09:44 PST 2016


#3672: Change aggregate functions to use new syntax
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  low      |  Milestone:  PostGIS 2.4.0
Component:  postgis  |    Version:  trunk
 Keywords:           |
---------------------+---------------------------
 For this, it's not necessary to drop existing (so no need to put in a
 Changed: ...).  Internally PostgreSQL shows the new syntax anyway.

 Just to keep our code base more up to date and make it easier to stuff
 args such as parallel = safe without having to rewrite the display.

 Note that most of our postgis aggs look like old syntax:

 {{{
 CREATE AGGREGATE some_agg( basetype = geometry ... )
 }}}

 But the newer syntax has been supported since at least PostgreSQL 8.4

 {{{
 CREATE AGGREGATE some_agg(geometry)( ... )
 }}}


 https://www.postgresql.org/docs/8.4/static/sql-createaggregate.html

 So we can certainly use in 2.1+


 https://www.postgresql.org/docs/8.4/static/sql-createaggregate.html

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3672>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list