[mapserver-users] Re: [postgis-users] sql works, but not as layer?

[Armin Burger]

Twan,

I don't know if it is still relevant for the current versions of
PostGIS/MapServer, but there was a posting by Dave Blasby about
subselects at

http://mapserver.gis.umn.edu/wilma/mapserver-users/0110/msg00283.html

Armin


> I'm sorry, but after tons of trying and recreating tables it still
doesn't
> work. I've simplyfied the query:

> CONNECTION "user=postgres dbname=food host=10.0.0.2"
> DATA "the_geom from (SELECT * from objecteigenschappen o left join
> pc6punten p on p.pc6=o.eigenschap_3) as foo"
> FILTER "pc6 like '1797%'"

> I still get the postgresql error "ERROR:  Attribute 'oid' not found",
but
> i
> have defined a index for oid for both (pc6punten en
objecteigenschappen)
> tables. Also geometry_columns table is correctly setup.

> Does anybody knows what is going wrong?

> Best regards,
> -twan

> At 09:43 4-6-2002 -0700, you wrote:
>> > CONNECTION "user=postgres dbname=food host=10.0.0.2"
>> > DATA "the_geom from objecteigenschappen o left join pc6punten p on
>> > p.pc6=o.eigenschap_3"
>> > FILTER "(the_geom && GeometryFromText('BOX3D(109258 559953,115258
>> > 565953)'::box3d,-1) and distance(the_geom,
>> > GeometryFromText('POINT(112258
>> > 562953)',-1)) < 3000)"
>>
>>
>>You're using the DATA parameter incorrectly - its a bit confusing.
>>
>>The generic templates are:
>>
>>DATA "<geom column name> from <table name>"
>>         or
>>DATA "<geom column name> from (<sql statement>) as foo"
>>
>>In your case, use:
>>
>>DATA "the_geom from (SELECT * from objecteigenschappen o left join
>>pc6punten p on p.pc6=o.eigenschap_3) as foo"
>>
>>hope that works,
>>
>>dave

> --
> http://www.twansoft.com