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

[Doug Cates]

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