[postgis-devel] [PostGIS] #1144: ST_MakeLine agregation error in order

[PostGIS]

#1144: ST_MakeLine agregation error in order
----------------------+-----------------------------------------------------
 Reporter:  arturbac  |       Owner:  pramsey      
     Type:  defect    |      Status:  new          
 Priority:  medium    |   Milestone:  PostGIS 2.0.0
Component:  postgis   |     Version:  1.5.X        
 Keywords:            |  
----------------------+-----------------------------------------------------

Comment(by robe):

 Arturbac,

 I fear this is not really a bug.  The example in the docs usually works,
 but there is nothing in the ANSI-SQL specs that guarantees the order of
 the sub query is preserved so on occasion the planner may choose not to
 respect the order. I've just never noticed it in PostgreSQL changing the
 order.

 If you are running PostgreSQL 9.0+, the guaranteed way is to use the new
 ORDER BY clause within the aggregation.  I've updated the svn manual to
 reflect the new way. Sadly it won't work unless you are using 9.0+ (the
 postgis version doesn't matter)

 http://www.postgis.org/documentation/manual-svn/ST_MakeLine.html

 Give that a try and see if that works better

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1144#comment:1>
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.