update question

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: update question
Date: 2003-03-06 16:41:42
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB04C74735@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Howdy:

Running PostgreSQL 7.2.1 on RedHat Linux 7.2.

I want to update a table, but I would like to know if I
have to use 'SET' in order for this to happen.

I have two tables that have the same structure, but
different data. They both have primary keys on the
first column (in this case, the column "name"). I
want to do something like:

update only table_a
from table_b
where table_a.name = table_b.name
;

But I keep getting an error saying there is
a problem after the 'from' ... so, I'm
guessing that I have to have SET somewhere ...

So ... why do I need SET and how can I work around this?

Thanks!

-X

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-03-06 16:42:02 Re: 7.4?
Previous Message Dennis Gearon 2003-03-06 16:16:05 Re: Shell Commands