Skip site navigation (1) Skip section navigation (2)

Re: Re: [Oledb-dev] double precision error with pg linuxserver, but not with windows pg server

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Shachar Shemesh <shachar(at)shemesh(dot)biz>
Cc: Greg Smith <gsmith(at)gregsmith(dot)com>, oledb-devel(at)pgfoundry(dot)org, postgres hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: [Oledb-dev] double precision error with pg linuxserver, but not with windows pg server
Date: 2007-05-21 13:53:29
Message-ID: 1179755609.3694.57.camel@coppola.muc.ecircle.de (view raw or flat)
Thread:
Lists: pgsql-hackers
> In other words, if I can assure that data exported and then imported
> will always, under all circumstances, compare the same to the original,
> would that be enough of a requirement? In other words, if I offer a
> format that is assured of preserving both mantissa and exponent
> precision and range, as well as all extra attributes (+/-Infinity and
> NaN), but does not guarantee that the semantically identical constructs
> are told apart (+0 vs. -0, and the different NaNs), would that format be
> acceptable?

If you care about the +/- for +/-Infinity, you must also care about +/-0
too, so you get the right type of infinity if you divide with 0... so +0
and -0 are far from being semantically identical.

Cheers,
Csaba.



In response to

Responses

pgsql-hackers by date

Next:From: Shachar ShemeshDate: 2007-05-21 13:58:37
Subject: Re: Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server
Previous:From: Tom LaneDate: 2007-05-21 13:43:47
Subject: Re: UTF8MatchText

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group