[postgis-users] spatial functions in PostGIS connection

[Kralidis,Tom [Burlington]]

Hi,

I have a point dataset in PostGIS which I display via OGC:WMS with no
problems:


  NAME "outbreaks"
  CONNECTIONTYPE postgis
  CONNECTION "user=postgres dbname=devgeodb2"
  DATA "the_geom from outbreaks"

..is it possible to embed PostGIS functions in the LAYER/DATA statement
like:

  NAME "outbreaks"
  CONNECTIONTYPE postgis
  CONNECTION "user=postgres dbname=devgeodb2"
  DATA "the_geom from outbreaks where distance(wkb_geometry,'POINT(-122
45)') = 10"

I tried this and got a ServiceException.  I also tried 

Thanks

..Tom