Proper Join and check
От
Patrick Nelson
Тема
Proper Join and check
Дата
Msg-id
4165C48DE9A0D211B6400800095C585F172E67@WASHINGTON
Список
Дерево обсуждения
Re: Proper Join and check Patrick Nelson <pnelson@neatech.com>
Re: Proper Join and check "Billy G. Allie" <Bill.Allie@mug.org>
If I have a one to many relation set on sym in each table is like... say
this:
CREATE TABLE "tableone" (
"sym" varchar(5) NOT NULL,
PRIMARY KEY ("sym") );
and
CREATE TABLE "tablemany" (
"id" int4 NOT NULL DEFAULT nextval('res_id_seq'::text),
"sym" varchar(5) REFERENCES tableone ON UPDATE CASCADE,
PRIMARY KEY ("id") );
Now these tables hold a lot of data so I want to do this correctly. How do
I find the records in tableone that don't have any corresponding records in
tablemany? In my application this shouldn't happen accept during the
initial inserting in tableone which briefly is followed by inserting in
tablemany.
В списке pgsql-general по дате отправления