pg_like.sql 300 B

123456
  1. --!syntax_pg
  2. select x like y from ( select 'a' as x, 'a%' as y) as a;
  3. select x ilike y from ( select 'a' as x, 'A%' as y) as a;
  4. select x like y from ( select 'a' as x, 'A%' as y) as a;
  5. select x like y from ( select 'a' as x, null as y) as a;
  6. select x like y from ( select null as x, 'a%' as y) as a;