Skip to content

Instantly share code, notes, and snippets.

@tangentstorm
Created May 16, 2013 23:43
Show Gist options
  • Save tangentstorm/5595987 to your computer and use it in GitHub Desktop.
Save tangentstorm/5595987 to your computer and use it in GitHub Desktop.
relational division
create table a (x integer);
create table b (y integer);
insert into a values (1);
insert into a values (2);
insert into b values (1);
insert into b values (2);
insert into b values (3);
select * from a,b;
-- result:
-- 1|1
-- 1|2
-- 1|3
-- 2|1
-- 2|2
-- 2|3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment