[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