updating records in table A from selected records in table B
| От | Robert Poor |
|---|---|
| Тема | updating records in table A from selected records in table B |
| Дата | |
| Msg-id | AANLkTi=7XyAb2YyxDtPgJMb1_ofAQC6wQpAe1GPrsdBu@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: updating records in table A from selected records in table B
|
| Список | 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 по дате отправления: