Tag: sql Tag: postgresql
SQLの配列変数
'{2018-02-15,2018-02-16}' などと書くと文字の配列になるらしい。
orだと記述が面倒な場合に、配列を使うとちょっとシンプルに書けるかな。
isao=# select * from denpyou where hizuke = any('{2018-02-15,2018-02-16}');
id | no | hizuke | tantou | shiire | zeisyori | gokei | szei | bikou
-------+-------+------------+--------+--------+----------+-------+------+--------
10001 | 10001 | 2018-02-15 | 01 | 11 | | 0 | 0 | memo01
10002 | 10002 | 2018-02-16 | 02 | 11 | | 0 | 0 | memo02
10003 | 10003 | 2018-02-16 | 01 | 12 | | 0 | 0 | memo02
(3 rows)
isao=# select * from denpyou where hizuke = '2018-02-15' or hizuke = '2018-02-16';
id | no | hizuke | tantou | shiire | zeisyori | gokei | szei | bikou
-------+-------+------------+--------+--------+----------+-------+------+--------
10001 | 10001 | 2018-02-15 | 01 | 11 | | 0 | 0 | memo01
10002 | 10002 | 2018-02-16 | 02 | 11 | | 0 | 0 | memo02
10003 | 10003 | 2018-02-16 | 01 | 12 | | 0 | 0 | memo02