[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: [postgis-users] Maximum depth of sub-queries
From: "Mark M" <fosters4all () beer ! com>
Date: 2004-11-26 12:49:38
Message-ID: 20041126124938.AB887398198 () ws5-1 ! us4 ! outblaze ! com
[Download RAW message or body]
Hi all,
I'm using postgresql/postgis/maplab for mapping. I have a query that works as a psql \
line command but when I transfer it into a map file I don't see an image nor an error \
message. Maybe my query is too intense any ideas?
Successful query;
select the_geom from (select * from (select locn_coord as the_geom, locn AS name,
lm_oid as oid, avg(obs_value) as phosphorous from
pwqmn.water_quality_view where obs_fk=10 GROUP BY locn_coord, lm_oid,
locn) AS foo WHERE phosphorous<0.02 ) as foo2;
Unsuccessful mapping statement;
CONNECTIONTYPE POSTGIS
DATA "the_geom from (select * from (select locn_coord as the_geom, locn AS name,
lm_oid as oid, avg(obs_value) as phosphorous from
pwqmn.water_quality_view where obs_fk=10 GROUP BY locn_coord, lm_oid,
locn) AS foo WHERE phosphorous<0.02 ) as foo2 USING UNIQUE oid USING SRID=-1"
TIA,
Mark
--
_______________________________________________
The coolest e-mail address on the web and it’s FREE! Sign-up today for Beer Mail @ \
beer.com.
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic