SQL NOT IN EMPTY LIST

sql_not_in_empty.sql

create table test (
  key text, 
  value text
);

insert into test (key, value) values ('1', 'Pulp Fiction');
insert into test (key, value) values ('2', 'Reservoir Dogs');
insert into test (key, value) values ('3', 'Inglorius Bastards');
insert into test (key, value) values ('4', 'Django');
insert into test (key, value) values ('5', 'Kill Bill');

-- Q1: SELECT ALL / return all items
select * from test;

-- Q2: SELECT ALL IN / return all items
select * from test where key in ('1', '3')
  union
select * from test where key not in ('1', '3');

-- Q3: SELECT ALL IN (null or empty sequence) / return NO items :(
select * from test where key in (null)
  union 
select * from test where key not in (null);