Date: Wed, 7 May 2003 18:40:25 +0200
From: "Jeroen T. Vermeulen" <jtv@xs4all.nl>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: GetValue(), floats, and locales
Message-ID: <20030507164025.GG48885@xs4all.nl>
Mail-Followup-To: Tom Lane <tgl@sss.pgh.pa.us>,
 pgsql-interfaces@postgresql.org
References: <20030507133633.GD48885@xs4all.nl>
 <27744.1052324342@sss.pgh.pa.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <27744.1052324342@sss.pgh.pa.us>
User-Agent: Mutt/1.4.1i

On Wed, May 07, 2003 at 12:19:02PM -0400, Tom Lane wrote:
> 
> The server should always ship floats in "standard" representation.
> AFAIK the only way to use localized numeric representations is to
> write to_char() and to_number() calls (or use the money datatype).
> If you can show us a case where plain float display does the other,
> it's a bug.

I personally can't show you anything except a bug report from my user,
but I'll encourage him to post it here.  He complains that libpqxx can't
read the fraction part of a floating-point number, which boils down to a
sscanf(GetValue(c,x,y), "%f", &f) always returning f as an integral 
value.

Of course it's also possible that there's a bug in his display code or
that I'm missing something very, very important.  Time to add some FP
test cases...


Jeroen