expr_op_array.sql 407 B

12345678910111213141516
  1. --!syntax_pg
  2. select 1 = any(array[1,2]),
  3. 1 = any(array[2,3]),
  4. 2 = all(array[2,2]),
  5. 2 = all(array[2,3]),
  6. 1 = any(array[null,1]),
  7. 1 = any(array[null,2]),
  8. 1 = all(array[null,1]),
  9. 1 = any(null::_int4),
  10. 1 = all(null::_int4),
  11. null = any(array[1,2]),
  12. null = all(array[1,2]),
  13. null = any(null::_int4),
  14. null = all(null::_int4);