[postgis-users] subselect on DATA tag

[John Hagstrand]

Hi David,

Thanks very much for the reply.  I tried the upper/lower case as you
suggested.  No change.

I am running on pghoster with postgreSQL version 7.2.x.  Is that too old for
this syntax?

Thanks
John

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of David
Blasby
Sent: Monday, July 14, 2003 11:40 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] subselect on DATA tag


I think you're using a very old version of mappostgis.c - grab a newer
one from the mapserver CVS.

You're probably running into the old upper/lowercase problem, try:

DATA "geo from (select id, geo, dtime from tstory) as foo USING
SRID=4326 USING UNIQUE id"

dave


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users