[postgis-users] finding items in polygon and sorting

[strk at refractions.net]

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

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