Re: Strange results when casting string to double - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Strange results when casting string to double
Date
Msg-id d07e34aa-0c42-f857-39d8-265d63998417@aklaver.com
Whole thread Raw
In response to Strange results when casting string to double  (Carsten Klein <c.klein@datagis.com>)
Responses Re: Strange results when casting string to double  (Carsten Klein <c.klein@datagis.com>)
List pgsql-general
On 2/16/22 05:27, Carsten Klein wrote:
> Hi there,
> 
> I'm using several (now unsupported) PostgreSQL 9.3.24 servers on 
> different (ancient) Ubuntu 14.04 LTS machines. On only one of those 
> servers, I get strange/wrong results when converting a string into a 
> double value:
> 

> Has anyone an idea of what's going on here? I know, this version is far 
> from still being supported, however, there's not much real changes in 
> file float.c between these versions (in other words, this may happen 
> with recent versions as well?). The database instances on all servers 
> are configured quite the same (more or less). 

What is the more or less for the problem server?

Are the hardware(CPU) architectures the same for all the servers?

If not how does the problem server differ?

Was Postgres installed from the same source/same way on all the server?


> All run with the same 
> extensions installed; none is using any preloaded libraries (which may 
> replace C library function strtod?).
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: if not exists (SELECT 1... UNION SELECT 1...)
Next
From: Adrian Klaver
Date:
Subject: Re: How to disable read-only mode on a table? (superUser)