Re: array_to_string return is different between Windows and Linux systems - Mailing list pgsql-general

From Magnus Hagander
Subject Re: array_to_string return is different between Windows and Linux systems
Date
Msg-id 20070123090121.GD14759@svr2.hagander.net
Whole thread Raw
In response to array_to_string return is different between Windows and Linux systems  (Pascal Lequeux <plequeux@zti.fr>)
List pgsql-general
On Tue, Jan 23, 2007 at 09:23:06AM +0100, Pascal Lequeux wrote:
> 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 ?

AFAIK, no. This is based on the operating system C library. It differs
between some other platforms as well IIRC - there are exceptions in the
regression tests for this.

//Magnus

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Problems compiling from source
Next
From: Csaba Nagy
Date:
Subject: Re: too many trigger records found for relation "item" -