[Mapserver-users] PostGIS - geometry from a stored function?

[Steve Lime]

That's what a FILTER is for. FILTERs are interpreted by the underlying
RDMS engine if applicable. For those datasources without one MapServer
does the evaluation. Even if MapServer does it there are performance
benefits since a feature is not read from disk unless is passes the
FILTER.

Steve

>>> Doug Cates <doug at moximedia.com> 12/1/2003 6:21:19 PM >>>
On a similar topic, I tried something like the following without
success. Is there some way of restricting features from a PostGIS data
source without using classes?

DATA "the_geom from point_table where year = 1997"

Doug

On Mon, 2003-12-01 at 09:38, Eric Bridger wrote:
> Is it possible to get the geometry from a Postgres stored function
using
> postGIS.
> e.g.
> 
> DATA "the_geom from (select * from GetGeom() as new_points using
unique
> gid using srid=-1"
> 
> 
> I tried this with a simple Postgres table function e.g.
> 
> CREATE OR REPLACE FUNCTION GetGeom() RETURNS SETOF point_table AS '
> select gid, buoy_id, water_depth, btype, the_geom, label_char,
> label_theta from point_table;
> 
> ' LANGUAGE 'sql';
> 
> Meanwhile:
> DATA "the_geom from point_table" works fine.
> 
> Thanks.
> 
> Eric
> 
> 
> 
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu 
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users 

_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu 
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users