just to follow up.
On i386/mipsel/mips I get the following for pow(10,309)
ERROR: result is out of range
on alpha, I get 3.09434604738258e-308
---------- Original Message -----------
From: "Jim Buttafuoco" <jim@contactbda.com>
To: "pgsql-hackers" <pgsql-hackers@postgresql.org>
Sent: Wed, 3 Nov 2004 08:44:02 -0500
Subject: [HACKERS] Fw: float4/float8 regression failure on Alpha Linux
> I am still having this problem with the latest CSV snapshot. Is anyone else running on an Alpha. Can any of
> the hackers point me to where in the code this might be failing?
>
> Thanks
> Jim
>
> ---------- Forwarded Message -----------
> From: "Jim Buttafuoco" <jim@contactbda.com>
> To: "pgsql-hackers" <pgsql-hackers@postgresql.org>
> Sent: Sun, 31 Oct 2004 07:09:32 -0500
> Subject: float4/float8 regression failure on Alpha Linux
>
> Hi all,
>
> I am getting a regression failure on float8 (and float4) when running on Debian Sarge on Alpha (gcc 3.3.4).
> Postgres is a HEAD checkout from yesterday.
>
> test=# select version();
> version
> -------------------------------------------------------------------------------------------------------
> PostgreSQL 8.0.0beta4 on alpha-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 (Debian 1:3.3.4-13)
> (1 row)
>
> --This test sould give an error
> SELECT 'Infinity'::float8 + 100.0;
> ?column?
> ----------
> 0
>
> Is this a problem with my system, Alpha's or postgres.
> Thanks
> Jim
> ------- End of Forwarded Message -------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
------- End of Original Message -------
