Hi List;
I have four parameters lat, lon, idlist and bufferlist. In a function I can
find if point (lat lon) is in distance within the defined (in idlist)
objects....
my_function(lon double precision, lat double precision, idlist character
varying, bufferlist character varying)
...
*The query is;*
query := 'select id ' ||
'from companyvectors inner join (Select
regexp_split_to_table('''||idlist||''', E''[,]+'') as a,
regexp_split_to_table('''||bufferlist||''', E''[,]+'') as b) as x ' ||
'on companyvectors.id=cast(x.a as bigint) ' ||
'where '||
'st_dwithin(st_transform(companyvectors.polygon_geom,900913),
st_transform(GeomFromText(''POINT('||lon||' '||lat||')'', 4326),900913),
cast(x.b as double precision));';
*What I need (it's faster) is a query something like (buffer is here
cast(x.b as double precision)**);*
polygon_geom && SetSRID('BOX2D(lat-buffer lon-buffer, lat+buffer
lon+buffer)', 4326)
Need help.. Thanks in Advance...
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
