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