[postgis-users] Double type and Buffer
Natalia
446047 at cepsz.unizar.es
Thu Jan 22 04:49:46 PST 2004
Hi everybody!
I need to use a BUFFER function (buffer (geometry,distance)) but i have
a problem with the distance(double type). In the documentation, it's said that
distance must be a double. I have done a explicit CAST to double
precision but postgis says :
"Function 'buffer(geometry, float8)' does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts "
My query is:
SELECT node_id
FROM mytable
WHERE within( the_geom ,BUFFER (
GeometryFromText('LINESTRING(-0.0007 40.0216,-0.0006 40.5009)', -1) ,
CAST (1000.01 as double precision)
) ) = 1
I have also tried to put other numbers like 0.999999999, 0.99999, other
CAST, creating a line and gets its length (because this function return
a double) but the same error appears.
I'm using 7.2.1 version, the binary compiled for Windows2000.
Any idea?
Thanks in advance!
Natalia
More information about the postgis-users
mailing list