Re: Wider than float8

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Vincenzo Romano <vincenzo(dot)romano(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Wider than float8
Date: 2007-06-08 19:00:35
Message-ID: 200706081900.l58J0Zm21666@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vincenzo Romano wrote:
> Hi all.
> On most modern CPUs there are numeric representations wider than 8-bytes
> (aka float8 in PGSQL).
>
> For example, Intel/AMD CPUs have native 12-bytes floating point numbers (aka
> long double in C/C++).
>
> I understand that it could not be non-standard from a clean SQL point of view.
> Nonetheless, is there any way to use those "long doubles" in SQL?

No. Frankly I didn't know 12-byte floats were supported in CPUs until
you posted this. You could write your own data type to use it, of
course.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-06-08 19:16:58 Re: Record Types Structure in PL/pgSQL
Previous Message Scott Marlowe 2007-06-08 18:58:26 Re: Limitations on 7.0.3?