GitHub user my-ship-it added a comment to the discussion: [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

> 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)
```

GitHub link: 
https://github.com/apache/cloudberry/discussions/1077#discussioncomment-13046901

----
This is an automatically sent email for dev@cloudberry.apache.org.
To unsubscribe, please send an email to: dev-unsubscr...@cloudberry.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@cloudberry.apache.org
For additional commands, e-mail: dev-h...@cloudberry.apache.org

Reply via email to