layer data source

[David Bitner]

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 <laura.diaz at iver.es> 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.
>