[mapserver-users] Retrieve function values from Postgres

[Heiko Schröter]

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