[postgis-users] finding items in polygon and sorting

strk at refractions.net strk at refractions.net
Mon Oct 10 23:37:53 PDT 2005

An index on the date column should help sort, check 
explain output with and w/out the index.

On Tue, Oct 11, 2005 at 12:22:15AM -0400, douglass_davis at earthlink.net wrote:
> Lets say if I want to find some items in a polygon and sort them...  For 
> example, all the "points" in Georgia, sorted by date of creation (also 
> in database).  There could be thousands of points.  I know that a 
> spatial index will help me find what's in Georgia, but is there any way 
> to make the subsequent sort faster?
> I didn't know if this was possible, but just asking.
> -- 
> http://www.douglassdavis.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list