[Geoserver-users] Buffer function

Hi list,

I’m new in the list. I’ve begun to work with Geoserver 3 weeks ago and it’s useful. Now I’m doing more complex things and I have a question:

I have two point tables (A,B) in postgis. I would like to do the query below using a GetFeature request with the filter option. Is it possible???

The query is:

select A.the_geom from A,B where
intersects(A.the_geom,buffer(B.the_geom,10000));

If it’s possible any help with the sintax??? I’ve tried to use the buffer function but it doesn’t work, I think it’s a syntax problem.

Thanks in advance.


Manel Gimeno