[Mapserver-users] postgis order by
dblasby at refractions.net
Mon Mar 15 13:01:04 EST 2004
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"
More information about the mapserver-users