You can use a PostgreSQL procedure that returns a geometry (or a set with one field being a geometry).
I use this a lot with cgi inputs to my procedure coming from url parameters so that I can have optional parameters without my select failing. Syntax: DATA "my_geom from myprocedure(%myfirstparam%,%mysecondparam%,%mythirdparam%) as mytable using unique myunique field using srid=mysrid" On 4/18/06, Laura Díaz <[EMAIL PROTECTED]> wrote: > Hi list, > is there any way to specify a different data source for a layer depending on > the request? > for instance, can i set the data of a postgis layer to a postgis table for > the map request > and to a complex view for the getFeatureInfo request? > or can i set the data of a layer as a procedure in the database? > > thanks, > > Laura. >
