Merge pull request OtterMind#1534 from tmlx1990/pg

Chat2DB-Pro · web-flow · commit a4464829d945 · 2024-09-25T20:31:18.000+08:00
Fix:PostgreSQL中DECIMAL、NUMERIC没有小数位问题。
diff --git a/README.md b/README.md
@@ -8,7 +8,7 @@
 
 # Chat2DB
 
-**English** | [中文](README_CN.md)· [Changelog](CHANGELOG.md) · [Doc](https://docs./) · [Report Bug](https://github.com/chat2db/Chat2DB/issues) · [PR](https://github.com/chat2db/Chat2DB/pulls)
+**English** | [中文](README_CN.md)· [Changelog](CHANGELOG.md) · [Doc](https://github.com/chat2db/Chat2db-website-old/blob/main/docs/index.md) · [Report Bug](https://github.com/chat2db/Chat2DB/issues) · [PR](https://github.com/chat2db/Chat2DB/pulls)
 
 </div>
 
@@ -65,6 +65,8 @@
 - huggingface🤗：[Chat2DB-SQL-7B](https://huggingface.co/Chat2DB/Chat2DB-SQL-7B)
 - modelscope：[Chat2DB-SQL-7B](https://modelscope.cn/models/Chat2DB/Chat2DB-SQL-7B/summary)
 
+### 🎁🎁🎁 Deploy the InternLM model on Chat2DB
+Thanks to [InternLM](https://github.com/InternLM/InternLM) for the strong support for this project. In the custom models of this project, multiple model weights from InternLM can be integrated. For more details, please refer to [chat2db-internlm-deploy](https://github.com/chat2db/chat2db-internlm-deploy)
 
 ## 🚀 Supported databases
 Chat2DB Pro supports all the following databases, including the most requested Redis feature.
diff --git a/README_CN.md b/README_CN.md
@@ -66,6 +66,8 @@
 - huggingface🤗：[Chat2DB-SQL-7B](https://huggingface.co/Chat2DB/Chat2DB-SQL-7B)
 - modelscope：[Chat2DB-SQL-7B](https://modelscope.cn/models/Chat2DB/Chat2DB-SQL-7B/summary)
 
+### 🎁🎁🎁 在Chat2DB上即成InternLM模型
+感谢InternLM对本项目的大力支持，在本项目中的自定义模型中，可以集成InternLM的多个模型权重，具体请参考[chat2db-internlm-deploy](https://github.com/chat2db/chat2db-internlm-deploy)
 
 ## 🚀 支持的数据库
 Chat2DB Pro支持以下所有数据库，包括备受期待的Redis功能。
diff --git a/chat2db-server/chat2db-plugins/chat2db-postgresql/src/main/java/ai/chat2db/plugin/postgresql/type/PostgreSQLColumnTypeEnum.java b/chat2db-server/chat2db-plugins/chat2db-postgresql/src/main/java/ai/chat2db/plugin/postgresql/type/PostgreSQLColumnTypeEnum.java
@@ -23,7 +23,7 @@ public enum PostgreSQLColumnTypeEnum implements ColumnBuilder {
     CIDR("CIDR", false, false, true, false, false, false, true, true, false, false),
     CIRCLE("CIRCLE", false, false, true, false, false, false, true, true, false, false),
     DATE("DATE", false, false, true, false, false, false, true, true, false, false),
-    DECIMAL("DECIMAL", true, false, true, false, false, false, true, true, false, false),
+    DECIMAL("DECIMAL", true, true, true, false, false, false, true, true, false, false),
     FLOAT4("FLOAT4", false, false, true, false, false, false, true, true, false, false),
     FLOAT8("FLOAT8", false, false, true, false, false, false, true, true, false, false),
     INET("INET", false, false, true, false, false, false, true, true, false, false),
@@ -37,7 +37,7 @@ public enum PostgreSQLColumnTypeEnum implements ColumnBuilder {
     LSEG("LSEG", false, false, true, false, false, false, true, true, false, false),
     MACADDR("MACADDR", false, false, true, false, false, false, true, true, false, false),
     MONEY("MONEY", false, false, true, false, false, false, true, true, false, false),
-    NUMERIC("NUMERIC", true, false, true, false, false, false, true, true, false, false),
+    NUMERIC("NUMERIC", true, true, true, false, false, false, true, true, false, false),
     PATH("PATH", false, false, true, false, false, false, true, true, false, false),
     POINT("POINT", false, false, true, false, false, false, true, true, false, false),
     POLYGON("POLYGON", false, false, true, false, false, false, true, true, false, false),
