From: | Joerg Fischer <fischer(at)zkm(dot)de> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | No DIVIDE Operator |
Date: | 1999-05-03 13:25:48 |
Message-ID: | 372DA3DC.8EEAF089@zkm.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Vadim Mikheev | 1999-05-03 13:28:59 | Re: [SQL] Slow Inserts Again |
Previous Message | Frank Morton | 1999-05-03 13:21:47 | Slow Inserts Again |