[Ideas] The goal is to introduce a new numeric type that combines the ​lossless precision of Numeric types with the ​computational efficiency of int or float

[cherchill2333]

Description

A new numeric type that combines the ​lossless precision of Numeric types with the ​computational efficiency of int or float types. This innovation would significantly enhance performance in monetary calculation scenarios.
For example, ​AnalyticDB PostgreSQL (ADB) includes a feature called ​Fixnumeric, which achieves this balance.

Use case/motivation

No response

Related issues

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

[my-ship-it]

You can refer to this project https://github.com/2ndQuadrant/fixeddecimal

[my-ship-it]

You can refer to this project https://github.com/2ndQuadrant/fixeddecimal

I compiled it against Cloudberry, which seems works.

postgres=# CREATE EXTENSION fixeddecimal;
CREATE EXTENSION
postgres=# select '1.239'::fixeddecimal;
 fixeddecimal
--------------
 1.23
(1 row)

postgres=# select version();
                                                                              version
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 14.4 (Apache Cloudberry 1.6.0+dev.1920.g1cbab9b build dev) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 9.5.0, 64-bit compiled on Apr 19 2025 11:54:30
(1 row)