Re: Working with fixed-point calculations in C - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: Working with fixed-point calculations in C
Date
Msg-id 20211208110336.bzux5hvczdamk2qk@hjp.at
Whole thread Raw
In response to Re: Working with fixed-point calculations in C  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 2021-12-07 22:41:38 -0500, Tom Lane wrote:
> I think what you are looking for is NUMERIC.  (The type name NUMBER
> is an Oracle-ism, I believe.  I'm not sure how closely that corresponds
> to our NUMERIC.)

Not very. Oracle NUMBER is a decimal floating point number with a 38
digit mantissa stored in a variable length format.

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: error connecting to pgbouncer admin console
Next
From: Shaozhong SHI
Date:
Subject: How to allow null as an option when using regexp_matches?