[mapserver-users] Retrieve function values from Postgres

[Stephen Woodbridge]

DATA "the_geom from (select * from get_aerosol_data('gas_db', 25.5, 
'2005-3-2 00:00', '2006-3-5 00:00') ) as foo using unique gid using 
srid=4326"

Here is a link that might help:

http://mapserver.org/input/vector/postgis.html

-Steve W

On 12/13/2012 3:24 PM, Lime, Steve D (DNR) wrote:
> 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
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users