[Mapserver-users] postgis order by

[Nick Petersen-Bergeron]

The order by seems to be ignored doing this.


At 10:01 AM 3/15/2004 -0800, David Blasby wrote:
>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

Nick Petersen-Bergeron
Developer

ZedX Inc.
369 Rolling Ridge Drive
Bellefonte, PA. 16823