Hello All,

I have a function that works well in postgres/postgis:

locationreport(reportdate date, longitude numeric, latitude numeric)

I want to use a parameterized SQL view to call this function, but I cannot seem 
to get the syntax correct.  I tried the following with no luck:

SELECT locationreport(%reportdate%, %longitude%, %latitude%);

What am I doing wrong?

Thanks,
Steve


Stephen Crawford

Center For Environmental Informatics

The Pennsylvania State University

src...@psu.edu
_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to