blob: 3a215748902c46f030e87c89367596f0ca82f777 (
plain) (
blame)
1
2
3
4
5
6
|
--!syntax_pg
select x like y from ( select 'a' as x, 'a%' as y) as a;
select x ilike y from ( select 'a' as x, 'A%' as y) as a;
select x like y from ( select 'a' as x, 'A%' as y) as a;
select x like y from ( select 'a' as x, null as y) as a;
select x like y from ( select null as x, 'a%' as y) as a;
|