[Mapserver-users] POSTGIS - subselect problem

[Ethan Alpert]

I believe you have an SQL syntax error.

SQL requires the a table to be referenced after from.

-e


-----Original Message-----
From: mapserver-users-admin@lists.gis.umn.edu
[mailto:mapserver-users-admin@lists.gis.umn.edu] On Behalf Of Alexandros
Chimarios
Sent: Tuesday, April 27, 2004 7:55 AM
To: Mapserver Users List
Subject: [Mapserver-users] POSTGIS - subselect problem



Hello, 

I have a problem with POSTGIS and in particular with subselects. I have
a 
POSTGIS layer and everything go well when i put :

DATA " geolocation from  unit_tracks USING UNIQUE unit_id   USING SRID =
-1 "


... but when i put the following data(which theoritically is the same
data 
with the previous one) I get a segmentation fault :

DATA " geolocation from (SELECT geolocation from unit_tracks) as foo
using 
unique oid using srid=-1  " 

Could anyone explain me what's happening here since subselecting is very

important thing.

Thanx

Alexandros. 
_______________________________________________
Mapserver-users mailing list
Mapserver-users@lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users

_______________________________________________
Mapserver-users mailing list
Mapserver-users@lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users