[Mapserver-users] postgis order by

[dblasby@refractions.net (David Blasby)]

Nick Petersen-Bergeron wrote:

> When using postgis/postgres with mapserver, is it possible to use an 
> order by statement to determine the order in which your geometries are 
> drawn?  If I put the order by in the data portion of the layer, no 
> errors are thrown, but the order by seems to be ignored.  If I include 
> it in the filter portion of the layer, an error is thrown and nothing is 
> drawn.  Any help would be appreciated.

Try something like:

DATA "the_geom from (SELECT id,the_geom FROM <table> ORDER BY ...) as 
foo USING UNIQUE id USING SRID=123"

dave