[postgis-devel] [PostGIS] #670: ST_SharedPaths

PostGIS trac at osgeo.org
Fri Dec 3 01:06:22 PST 2010


#670: ST_SharedPaths
---------------------+------------------------------------------------------
 Reporter:  strk     |       Owner:  strk         
     Type:  defect   |      Status:  new          
 Priority:  high     |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by strk):

 Note the table was created with this query:
 {{{
 strk=# create table bug670 as SELECT foo1.the_geom as g1, foo2.the_geom As
 g2
  FROM ((SELECT ST_SetSRID(ST_Point(i,j),4326) As the_geom FROM
  (SELECT a*1.11111111 FROM generate_series(-10,50,10) As a) As i(i) CROSS
  JOIN generate_series(40,70, 15) j ORDER BY i,j )) As foo1 CROSS JOIN
  ((SELECT ST_Buffer(ST_SetSRID(ST_Point(i,j),4326), j*0.05) As the_geom
  FROM (SELECT a*1.11111111 FROM generate_series(-10,50,10) As a) As i(i)
  CROSS JOIN generate_series(40,70, 20) As j ORDER BY i, i*j, j)) As foo2
  LIMIT 2;
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/670#comment:6>
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-devel mailing list