[postgis-users] Different results on different Platforms: PostGIS 1.5

[Ahmed Shinwari]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100728/9db2418c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test_scenario.sql
Type: application/octet-stream
Size: 9432 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100728/9db2418c/attachment.obj>