array_to_string return is different between Windows and Linux systems

From: Pascal Lequeux <plequeux(at)zti(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: array_to_string return is different between Windows and Linux systems
Date: 2007-01-23 08:23:06
Message-ID: 45B5C5EA.2030302@zti.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

The *array_to_string *function used to compare the content of arrays of
doubles doesn't return the same result if the OS is Windows or if it is
a Linux system.

Here is an example using the same table content:
Result 1: "0,0.000263,*8e-06*,*8e-06*,0.000146,0.000321" [PostgreSQL
8.0.4 (redhat) or 8.1.5 (OpenSuse 10.2)]
Result 2: "0,0.000263,*8e-006*,*8e-006*,0.000146,0.000321" [PostgreSQL
8.1.4, 8.1.5 or 8.1.6 (Windows)]
The string compare fails!

Is there a way to fix the exponent size ?

--

Best regards,
Pascal Lequeux

plequeux(at)zti(dot)fr
----------------------------------------
ZTI
1 Bd d'Armor
BP 20254
22302 LANNION Cedex
FRANCE
----------------------------------------
Tel.: +33 2 96 48 43 43
Fax.: +33 2 96 48 14 85
Web: http://www.zti.fr ou http://www.zti-telecom.com
----------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2007-01-23 08:28:11 Re: MSSQL/ASP migration
Previous Message Martijn van Oosterhout 2007-01-23 07:41:42 Re: Regular expressions and arrays and ANY() question