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