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 по дате отправления
От: Oleg Bartunov
Дата:
От: Patrick Nelson
Дата:
Сообщение: Re: Proper Join and check
FAQ