updating records in table A from selected records in table B - Mailing list pgsql-novice

From Robert Poor
Subject updating records in table A from selected records in table B
Date
Msg-id AANLkTi=7XyAb2YyxDtPgJMb1_ofAQC6wQpAe1GPrsdBu@mail.gmail.com
Whole thread Raw
Responses Re: updating records in table A from selected records in table B
List pgsql-novice
I've pored over the syntax for UPDATE but I think I'm missing something.

Assuming a schema such as:

      Column       |            Type             |
    Modifiers
--------------------+-----------------------------+------------------------------------------------------------
 id                 | integer                     | not null default
nextval('service_bills_id_seq'::regclass)
 fk                 | integer                     |
 start_time         | timestamp without time zone |
 quantity           | numeric(10,5)               |
 cost               | numeric(10,5)               |

Starting with the results from this query:

     SELECT candidates.quantity, candidates.cost
         FROM table_b AS candidates
INNER JOIN table_a AS incumbents
             ON incumbents.fk = candidates.fk
           AND incumbents.start_time = candidates.start_time

... is there a way to update quantity and cost fields in incumbents
with the matching records from candidates?  It seems that UPDATE is
designed only to update one record at a time...

pgsql-novice by date:

Previous
From: Robert Poor
Date:
Subject: Re: inserting a NULL timestamp
Next
From: aaronenabs
Date:
Subject: pg_dumpall