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

Re: [HACKERS] Re: Trouble with float4 afterupgrading from 6.5.3 to 7.0.2

From: <vectro(at)pipeline(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Philip Warner <pjw(at)rhyme(dot)com(dot)au>, Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, Romanenko Mikhail <mikhail(at)angg(dot)ru>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Re: Trouble with float4 afterupgrading from 6.5.3 to 7.0.2
Date: 2000-08-06 21:36:19
Message-ID: Pine.LNX.4.10.10008061433470.22893-100000@nemo.house (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
> I suppose we could implement the conversion as "float8in(float4out(x))"
> instead of "(double) x" but it'd be several orders of magnitude slower,
> as well as being *less* useful to those who know what they're doing with
> float math (since the result would actually be a less-precise conversion
> except in cases where the intended value has a short decimal
> representation).

We only need to maintain the lower-order bit(s). Seems this could be done
a lot easier than by an ascii in-between.

Is there a reason we can't perform the conversion and then copy the
low-order bits manually, with some bit-shifting and masking?

Ian


In response to

Responses

pgsql-hackers by date

Next:From: Thomas LockhartDate: 2000-08-06 23:59:30
Subject: LIKE pattern matching
Previous:From: The Hermit HackerDate: 2000-08-06 19:08:52
Subject: Re: scp daemon working?

pgsql-general by date

Next:From: vectroDate: 2000-08-07 00:04:28
Subject: Re: [HACKERS] Re: Trouble with float4 afterupgrading from 6.5.3 to 7.0.2
Previous:From: Stephan SzaboDate: 2000-08-06 21:26:17
Subject: Re: foreign keys

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