UPDATE across tables

Поиск

Список

Период

Сортировка

От	Jake Matchett
Тема	UPDATE across tables
Дата	7 августа 2002 г. 08:44:53
Msg-id	sd510c15.047@gwmail.nottingham.ac.uk обсуждение
Ответы	Re: UPDATE across tables
Список	pgsql-novice

Дерево обсуждения

I need to update the primary key field in two tables sharing this field, I can't update separately because I get an integrity violation message that tells me the field is still being referenced from the other table, fair enough but is there any way of doing a joined/linked/double update to the primary key of both tables simultaneously? Something like: UPDATE table1.fieldx, table2.fieldx SET fieldx='yyyyy' WHERE fieldx='zzzzz';

Jake Matchett
The University of Nottingham
Media Centre
Medical School, Queen's Medical Centre
Nottingham NG7 2UH
(74) 44001
voice +44 (0) 115 9249924 ext 44001
fax +44 (0) 115 9709917
< http://www.nottingham.ac.uk/aves/ >

В списке pgsql-novice по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

UPDATE across tables