|

»

[PostGIS] #292: Can not order by geography

View: New views

6 Messages — Rating Filter: Alert me

	[PostGIS] #292: Can not order by geography by PostGIS-4 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message #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 Keywords: \| ---------------------+------------------------------------------------------ Not sure to consider this a bug or not, except that I can order by a geometry column and I can't by geography. get error ERROR: could not identify an ordering operator for type geography. -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/292> PostGIS <http://trac.osgeo.org/postgis/> PostGIS _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel
	Re: [PostGIS] #292: Can not order by geography by PostGIS-4 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message #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 robe): For completeness these are the situations where this shows its ugly head {{{ -- the obvious order by SELECT g.gid, g.the_geog FROM g ORDER BY g.the_geog; }}} {{{ -- the group by SELECT g.gid, g.the_geog, SUM(sales) FROM g INNER JOIN finl ON g.gid = finl.gid GROUP BY g.gid, g.the_geog; }}} {{{ -- the distinct SELECT DISTINCT g.gid, g.the_geog FROM g }}} {{{ -- the equality which questionably -- well has to be allowed but prone to abuse -- get error: ERROR: operator does not exist: geography = geography -- No operator matches the given name and argument type(s). -- You might need to add explicit type casts. SELECT g.gid,g.the_geog FROM g WHERE g.the_geog = ST_GeographyFromText('POINT(1 2)'); }}} -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/292#comment:1> PostGIS <http://trac.osgeo.org/postgis/> PostGIS _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel
	Re: [PostGIS] #292: Can not order by geography by PostGIS-4 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message #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 _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel
	Re: [PostGIS] #292: Can not order by geography by PostGIS-4 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message #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): Any thoughts on the meaning of the >, < and = operators? I've committed a stub implementation that works against the geocentric box centers for now (r4779) -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/292#comment:3> PostGIS <http://trac.osgeo.org/postgis/> PostGIS _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel
	Re: [PostGIS] #292: Can not order by geography by PostGIS-4 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message #292: Can not order by geography ----------------------+----------------------------------------------------- Reporter: robe \| Owner: pramsey Type: defect \| Status: closed Priority: medium \| Milestone: postgis 1.5.0 Component: postgis \| Version: trunk Resolution: fixed \| Keywords: ----------------------+----------------------------------------------------- Changes (by pramsey): * status: new => closed * resolution: => fixed Comment: I've committed a simple version that uses box centers. If we ever create a hhkey generator or something like that, we can do something more elegant. -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/292#comment:4> 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. _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel
	Re: [PostGIS] #292: Can not order by geography by PostGIS-4 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message #292: Can not order by geography ----------------------+----------------------------------------------------- Reporter: robe \| Owner: pramsey Type: defect \| Status: closed Priority: medium \| Milestone: postgis 1.5.0 Component: postgis \| Version: trunk Resolution: fixed \| Keywords: ----------------------+----------------------------------------------------- Comment (by pramsey): The commit went into trunk at r4814 -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/292#comment:5> 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. _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel