postgresql, numeric(12,4) should be float in struct, but got int64

[zhouzun8709]

Describe the bug A clear and concise description of what the bug is.

To Reproduce Steps to reproduce the behavior, if applicable:

1. The code is

2. The error is

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Environments (please complete the following information):

• OS: [e.g. Linux]
• go-zero version [e.g. 1.2.1]
• goctl version [e.g. 1.2.1, optional]

More description Add any other context about the problem here.

[zhouzun8709]

postgresql 某a字段类型int2 ,go 结构体中int64 字段a,做条件查询时返回： pq: operator does not exist: ` smallint

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

postgresql a field type int2, int64 field a in the go structure, return when doing conditional query: pq: operator does not exist: ` smallint

[M-MoMoMo]

This problem has not been solved so far.

[kevwan]

@anqiansong

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

@Anxi sent

[github-actions[bot]]

This issue is stale because it has been open for 30 days with no activity.

[github-actions[bot]]

This issue was closed because it has been inactive for 14 days since being marked as stale.