[mapserver-users] Retrieve function values from Postgres

[Lime, Steve D (DNR)]

I believe anything you can stuff in a DATA statement using SQL is legitimate. 

________________________________________
From: mapserver-users-bounces at lists.osgeo.org [mapserver-users-bounces at lists.osgeo.org] on behalf of Heiko Schröter [schroete at iup.physik.uni-bremen.de]
Sent: Tuesday, December 11, 2012 6:13 AM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] Retrieve function  values from Postgres

Hello,

is it possible for mapserver to question a function in a postgres geo
database ?
i.e. this query string inside postgres  works:
"select * from get_aerosol_data('gas_db', 25.5, '2005-3-2 00:00',
'2006-3-5 00:00');"

If it is possible how to translate this into mapserver mapfile syntax ?

Thanks and Regards
Heiko


/mdraid/www/localhost/mapserver/mapserv -v
MapServer version 6.0.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML
SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER
SUPPORTS=FASTCGI INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users