[postgis-users] Double type and Buffer
Tyler Mitchell
TMitchell at lignum.com
Thu Jan 22 08:42:24 PST 2004
I meant to add as well, that there may be some ways people are doing
buffers without needing the additional GEOS library.
postgis-users-bounces at postgis.refractions.net wrote on 01/22/2004 04:49:46
AM:
> 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'ssaid
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
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
More information about the postgis-users
mailing list