我正在使用postgresql。
假設我有這個表名my_table：
id | idcm | stores | du | au | dtc |
----------------------------------------------------------------------------------
1 | 20447 | [2, 5] | 2022-11-02 | 2022-11-15 | 2022-11-03 11:12:19.213799 01 |
2 | 20456 | [2, 5] | 2022-11-02 | 2022-11-15 | 2022-11-03 11:12:19.213799 01 |
3 | 20478 | [2, 5] | 2022-11-02 | 2022-11-15 | 2022-11-03 11:12:19.213799 01 |
4 | 20482 | [2, 5] | 2022-11-02 | 2022-11-15 | 2022-11-03 11:12:19.213799 01 |
5 | 20485 | [2, 5] | 2022-11-02 | 2022-11-15 | 2022-10-25 20:25:08.949996 02 |
6 | 20497 | [2, 5] | 2022-11-02 | 2022-11-15 | 2022-10-25 20:25:08.949996 02 |
7 | 20499 | [2, 5] | 2022-11-02 | 2022-11-15 | 2022-10-25 20:25:08.949996 02 |
我只想選擇值idm等于stores（該行的）陣列元素之一的行。
所以我想得到這樣的東西：
id | idcm | stores | du | au | dtc |
----------------------------------------------------------------------------------
2 | 20456 | [2, 5] | 2022-11-02 | 2022-11-15 | 2022-11-03 11:12:19.213799 01 |
5 | 20485 | [7, 5] | 2022-11-02 | 2022-11-15 | 2022-10-25 20:25:08.949996 02 |
6 | 20497 | [2, 6] | 2022-11-02 | 2022-11-15 | 2022-10-25 20:25:08.949996 02 |
7 | 20499 | [5, 7] | 2022-11-02 | 2022-11-15 | 2022-10-25 20:25:08.949996 02 |
我試過了
select * from my_table where id in stores;
但我得到一個語法錯誤。
uj5u.com熱心網友回復：
您需要使用ANY()運算子：
select *
from my_table
where id = any(stores);
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/526532.html