Hello, is it right, that i I would want to make any changes to how the data from PostGIS is queried, I would have to make in GeoTools?
The thing is, that I would like to query a function with custom parameters which returns a ResultSet. GeoServer only sees GEO-enabled views & tables and I cannot set any parameters. I would like a view with something similar to this but having x,y,tx and ty dynamically substituted. --------- CREATE OR REPLACE VIEW myview AS SELECT planet_osm_roads.name, planet_osm_roads.way, AsSVG(simplify(st_affine(planet_osm_roads.way,x,0,0,y,tx,ty),2),1) AS assvg FROM planet_osm_roads; ----------- Searching the web now for a while I figured out, that it is not possible to pass variables to a view. So i figured I would intercept and modify the SELECT query...although it is ugly, I know. Thanks a lot Ivo ------------------------------------------------------------------------------ SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________ Geoserver-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-devel
