Hi Ivo, You are correct that GeoServer uses GeoTools for all access to PostGIS. In particular code living in the postgis module:
http://svn.osgeo.org/geotools/trunk/modules/plugin/postgis/ For a while we have been talking about adding support for on the fly queries as feature types... not sure if this falls into your use case. How exactly are x,y,tx,ty generated? -Justin Ivo Brodien wrote: > 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 -- Justin Deoliveira OpenGeo - http://opengeo.org Enterprise support for open source geospatial. ------------------------------------------------------------------------------ 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
