Hi All, I am using Postgres Plus 8.4 and the PostGIS 1.4 along with it. The problem is that I get different results on Windows XP & Linux-32 (Red Hat 5) from the same query.
The SQL script is a bit lengthy so I have attached it with this email.
Please run that SQL script file on psql terminal so that all of the
pre-requisite Tables and Functions are created. At the end of this script
there are two queries. I have pasted below the two queries and there results
with respect to the two OS'.
QUERY 1: SELECT area(the_geom) FROM buildings;
-- Result on Windows XP
area
------------------
205.548500000002
(1 row)
-- Result on Linux32 (Red Hat 5)
area
------------------
205.5485
(1 row)
QUERY 2: SELECT length(geom) FROM roads;
-- Result on Windows XP
length
-----------------
14.142135623731
(1 row)
-- Result on Linux32 (Red Hat 5)
length
-----------------
14.1421356237309
(1 row)
The output from Query 1 is a bit bizarre. Instead of rounding and truncating
it on Windows, '00000002' is appended to it. Is this normal? Or is it a bug.
And also the output from Query 2 is different as well.
Thanking in advance for any assistance.
Regards,
Ahmed
test_scenario.sql
Description: Binary data
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
