Hi Ahmed, Are we talking about the same CPU? Those differences are small enough to be the result of different assembler code fed into different processors.
Personally, I wouldn't worry much about it. Rounding both results gets you equal results. Luís On Wed, Jul 28, 2010 at 5:25 PM, Ahmed Shinwari <[email protected]>wrote: > 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 > > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
