Slick way to update multiple tables.
| От | Theodore M Rolle, Jr. |
|---|---|
| Тема | Slick way to update multiple tables. |
| Дата | |
| Msg-id | CAPDmd-AQ9M_DGEuttxB25TGCkQxT=WqU=p4_0AVKVTiJNBfbLA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Slick way to update multiple tables.
Re: Slick way to update multiple tables. |
| Список | pgsql-general |
I SELECT items from three tables.
It seems that the only way to put updated fields into their proper table is to query each field, then UPDATE each table.
Am I missing something here?
Is there a way to do this automatically?
GnuPG/PGP key: 0xDD4276BA
+-----------------------------------------------------------------------------------------------------+
| 3.14159 26535 89793 23846 26433 83279 50288 41971 69399 37510 |
| 58209 74944[59230 78164]06286 20899 86280 +----------------------------------|
| 34825 34211 70679*82148 08651 32823 06647 | May the spirit |
| 09384 46095 50582 23172 53594 08128 48111 | of π spread |
| 74502 84102 70193 85211 05559 64462 29489 | around the world. |
| 54930 38196 44288 10975 66593 34461 28475 | PI VOBISCUM! |
| 38196 44288 10975 66593 34461 28475 64823 +---------------------------------|
| 37867 83165 27120 19091 45648 56692 34603 48610 45432 6648... |
+----------------------------------------------------------------------------------------------------+
В списке pgsql-general по дате отправления: