in_with_cast.sql 297 B

12345678
  1. /* postgres can not */
  2. SELECT
  3. Null in (100500) as `void`,
  4. Just(cast(1 as Uint8)) in (23, Null, 32, Null, 255) as byte_wrap_match,
  5. cast(5 as int64) in (1, 5, 42l) as different_types,
  6. 3.14 in (1, 3, 4) as pi_not_exact,
  7. 3.14 in (1, 3, 4, 3 + 0.14) as pi_in_expr,
  8. 'end' as end