Re: Wider than float8 - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Wider than float8
Date
Msg-id 200706081900.l58J0Zm21666@momjian.us
Whole thread Raw
In response to Wider than float8  (Vincenzo Romano <vincenzo.romano@gmail.com>)
Responses Re: Wider than float8  (felix@crowfix.com)
List 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@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

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

pgsql-general by date:

Previous
From: MC Moisei
Date:
Subject: Postmaster processes taking all the CPU
Next
From: Scott Marlowe
Date:
Subject: Re: Limitations on 7.0.3?