Hi!
Consider the following szenario:
Two Tables:
create table Person ( name text, prename text, street text, town text
);
create table Officer ( name text, prename text, bureau text
);
So, every Officer is a Person. Now, I would like to get all persons
except for Officers.
If there would be a divide operator, I could write
select name, prename from Person divide select name, prename from
Officer;
without it, however, things get really complicated:
select name, prename from Person where prename not in ( select prename
from Officer where Officer.name = Person.name );
This is an easy example. However, I have to deal with about 10 tables in
a corresponding way.
Any better idea? Will there be a divide operator in PGSQL soon?
Thanks!
Regards
Joerg Fischer