[postgis-devel] [PostGIS] #292: Can not order by geography

PostGIS trac at osgeo.org
Tue Nov 10 12:36:42 PST 2009


#292: Can not order by geography
----------------------+-----------------------------------------------------
  Reporter:  robe     |       Owner:  pramsey      
      Type:  defect   |      Status:  new          
  Priority:  medium   |   Milestone:  postgis 1.5.0
 Component:  postgis  |     Version:  trunk        
Resolution:           |    Keywords:               
----------------------+-----------------------------------------------------
Comment (by pramsey):

 Create a test table
 {{{
 create table g as select
   lon * 100 + lat as gid,
   geography(st_setsrid(st_buffer(st_makepoint(lon, lat),1.0),4326)) as
 the_geog
 from (
   select lon,
   generate_series(-80,80, 5) as lat
 from (
   select generate_series(-175, 175, 5) as lon) as sq1) as sq2;
 alter table g add primary key ( gid );
 create index g_geomidx on g using gist ( the_geog );
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/292#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS


More information about the postgis-devel mailing list