Postgres Pro
Downloads
Home   >   mailing lists

Slick way to update multiple tables. - Mailing list pgsql-general

From Theodore M Rolle, Jr.
Subject Slick way to update multiple tables.
Date
Msg-id CAPDmd-AQ9M_DGEuttxB25TGCkQxT=WqU=p4_0AVKVTiJNBfbLA@mail.gmail.com
Whole thread Raw
Responses Re: Slick way to update multiple tables.  (Michael Lewis <mlewis@entrata.com>)
Re: Slick way to update multiple tables.  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How to implement expiration in PostgreSQL?
Next
From: Michael Lewis
Date:
Subject: Re: Slick way to update multiple tables.