{"id":207582,"date":"2025-07-08T09:52:56","date_gmt":"2025-07-08T01:52:56","guid":{"rendered":"https:\/\/server.hk\/cnblog\/207582\/"},"modified":"2025-07-08T09:52:56","modified_gmt":"2025-07-08T01:52:56","slug":"%e8%87%aa%e5%8a%a8%e8%bf%81%e7%a7%bb%e5%88%b0-postgresql-%e6%97%b6%e5%bc%ba%e5%88%b6-gorm-%e4%bd%bf%e7%94%a8%e7%89%b9%e5%ae%9a%e7%9a%84-integer-%e7%b1%bb%e5%9e%8b","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/207582\/","title":{"rendered":"\u81ea\u52a8\u8fc1\u79fb\u5230 PostgreSQL \u65f6\u5f3a\u5236 GORM \u4f7f\u7528\u7279\u5b9a\u7684 INTEGER \u7c7b\u578b"},"content":{"rendered":"<p><b><\/b> <\/p>\n<p>\u5f53\u524d\u4f4d\u7f6e\uff1a <span>&gt;<\/span> <span>&gt;<\/span> <span>&gt;<\/span> <span>&gt;<\/span> <span>\u81ea\u52a8\u8fc1\u79fb\u5230 PostgreSQL \u65f6\u5f3a\u5236 GORM \u4f7f\u7528\u7279\u5b9a\u7684 INTEGER \u7c7b\u578b<\/span><\/p>\n<p><span>\u6765\u6e90\uff1astackoverflow<\/span><br \/>\n<span>2024-04-23 19:12:36<\/span><br \/>\n<span><i><\/i>0\u6d4f\u89c8<\/span><br \/>\n<span style=\"cursor: pointer\"><i><\/i>\u6536\u85cf<\/span> <\/p>\n<p>\u4eb2\u7231\u7684\u7f16\u7a0b\u5b66\u4e60\u7231\u597d\u8005\uff0c\u5982\u679c\u4f60\u70b9\u5f00\u4e86\u8fd9\u7bc7\u6587\u7ae0\uff0c\u8bf4\u660e\u4f60\u5bf9\u300a\u81ea\u52a8\u8fc1\u79fb\u5230 PostgreSQL \u65f6\u5f3a\u5236 GORM \u4f7f\u7528\u7279\u5b9a\u7684 INTEGER \u7c7b\u578b\u300b\u5f88\u611f\u5174\u8da3\u3002\u672c\u7bc7\u6587\u7ae0\u5c31\u6765\u7ed9\u5927\u5bb6\u8be6\u7ec6\u89e3\u6790\u4e00\u4e0b\uff0c\u4e3b\u8981\u4ecb\u7ecd\u4e00\u4e0b\uff0c\u5e0c\u671b\u6240\u6709\u8ba4\u771f\u8bfb\u5b8c\u7684\u7ae5\u978b\u4eec\uff0c\u90fd\u6709\u5b9e\u8d28\u6027\u7684\u63d0\u9ad8\u3002<\/p>\n<p> \u95ee\u9898\u5185\u5bb9<br \/>\n <\/p>\n<p>\u6211\u7684 go \u6a21\u578b\u662f\uff1a<\/p>\n<pre>type Sales_Daily_db struct {\n    Nation_shipping string\n    Date             datatypes.Date\n    Impressions      int `gorm:\"type:integer;\"`\n    Clicks           int `gorm:\"type:integer;\"`\n    Cost             float32\n    ATB              float32\n    OKL              float32\n}<\/pre>\n<p>\u4f7f\u7528\u4e0a\u8ff0\u6a21\u578b\u8fd0\u884c <code>automigrate()<\/code> \u65f6\uff0c\u6211\u5e0c\u671b psql \u6570\u636e\u5e93\u4e2d\u7684 <code>impressions<\/code> \u548c <code>clicks<\/code> \u5217\u7684\u7c7b\u578b\u4e3a <code>integer<\/code>\u3002\u7136\u800c\uff0c\u5373\u4f7f\u4f7f\u7528\u8fd9\u4e9b <code>gorm<\/code> \u6807\u7b7e\uff0c\u5b83\u4eec\u4ecd\u7136\u6700\u7ec8\u6210\u4e3a <code>int4<\/code> \u7c7b\u578b\u3002\u6211\u5df2\u7ecf\u4f7f\u7528\u4e0a\u9762\u7684\u6807\u7b7e\u624b\u52a8\u5c1d\u8bd5\u4e86 <code>int2 int4 int8<\/code> \uff0c\u5b83\u4eec\u90fd\u76f8\u5e94\u5730\u5de5\u4f5c\u4e86\u3002\u6b64\u5916\uff0c\u5f53\u6211\u5c1d\u8bd5 <code>int<\/code> \u6807\u8bb0\u65f6\uff0c\u5b83\u4eec\u88ab\u5f3a\u5236\u8fdb\u5165 <code>int8<\/code>\u3002\u5982\u4f55\u4fee\u590d\u6b64\u884c\u4e3a\u5e76\u5728 psql \u4e2d\u4e13\u95e8\u83b7\u53d6 <code>integer<\/code> \u7c7b\u578b\uff1f<\/p>\n<p>\u7f16\u8f91\uff1a\u6211\u6b63\u5728\u4f7f\u7528 dbeaver \u67e5\u770b\u6570\u636e\u5e93\u3002<\/p>\n<p> <\/p>\n<h2>\u6b63\u786e\u7b54\u6848<\/h2>\n<p> <\/p>\n<p>\u6839\u636e postgresql \u6587\u6863\uff0c\u8fd9\u6837\u8bf4\uff1a<\/p>\n<pre>SQL only specifies the integer types integer (or int), smallint, and bigint.  \nThe type names int2, int4, and int8 are extensions, which are also used by some other SQL database systems.<\/pre>\n<p>\u60a8\u5e94\u8be5\u53ef\u4ee5\u4f7f\u7528 <code>int<\/code>\u3001<code>integer<\/code>\u3001<code>smallint<\/code> \u548c <code>bigint<\/code>\u3002\u9664\u6b64\u4e4b\u5916\u7684\u4efb\u4f55\u5185\u5bb9\u90fd\u53ea\u662f\u522b\u540d\u3002<\/p>\n<p>\u5230\u8fd9\u91cc\uff0c\u6211\u4eec\u4e5f\u5c31\u8bb2\u5b8c\u4e86\u300a\u81ea\u52a8\u8fc1\u79fb\u5230 PostgreSQL \u65f6\u5f3a\u5236 GORM \u4f7f\u7528\u7279\u5b9a\u7684 INTEGER \u7c7b\u578b\u300b\u7684\u5185\u5bb9\u4e86\u3002\u4e2a\u4eba\u8ba4\u4e3a\uff0c\u57fa\u7840\u77e5\u8bc6\u7684\u5b66\u4e60\u548c\u5de9\u56fa\uff0c\u662f\u4e3a\u4e86\u66f4\u597d\u7684\u5c06\u5176\u8fd0\u7528\u5230\u9879\u76ee\u4e2d\uff0c\u6b22\u8fce\u5173\u6ce8\u516c\u4f17\u53f7\uff0c\u5e26\u4f60\u4e86\u89e3\u66f4\u591a\u5173\u4e8e\u7684\u77e5\u8bc6\u70b9\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5f53\u524d\u4f4d\u7f6e\uff1a &gt; &gt; &#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4925],"tags":[],"class_list":["post-207582","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/207582","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/comments?post=207582"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/207582\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=207582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=207582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=207582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}