From: Matthew Price <pricem@juno.com>
To: pgsql-sql@postgresql.org
Subject: Updating a table from another table
Date: Tue, 4 Jun 2002 20:37:30 GMT
Message-ID: <20020604.163820.15423.68377@wm13.nyc.untd.com> (raw)
Howdy All,
I need to update many records in one table with data from another table that ultimately gets \copy-ed from an outside source.
customers:
custnum varchar(6),
name text,
canceldate date
...
cancels:
custnum varchar(6),
canceldate date
What is the right way to update the canceldate in the customers table from canceldate in the cancels table? Is there a way to use update to iterate rather than making a mass change?
Thanks in advance,
Matthew
________________________________________________________________
GET INTERNET ACCESS FROM JUNO!
Juno offers FREE or PREMIUM Internet access for less!
Join Juno today! For your FREE software, visit:
http://dl.www.juno.com/get/web/.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pricem@juno.com
Subject: Re: Updating a table from another table
In-Reply-To: <20020604.163820.15423.68377@wm13.nyc.untd.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox