Skip site navigation (1) Skip section navigation (2)

can I update multiple table at a time?

From: Jagadeesh <mnjagadeesh(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: can I update multiple table at a time?
Date: 2008-10-10 05:12:04
Message-ID: 4ba626d0-b2b5-4421-8df1-1bb39d4a858b@t39g2000prh.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hello Gurus,

Is it possible to update two table using single sql statement? huh?
let me be clear

I have table master with state and date field. And in history table I
have same fields i.e., state and date. I'm writing an update statement
to set 'open' state records  to 'closed' state after 7. both table can
be joined using id.

Any thoughts?

Thanks

Responses

pgsql-admin by date

Next:From: Joshua DrakeDate: 2008-10-10 05:53:51
Subject: Re: can I update multiple table at a time?
Previous:From: JagadeeshDate: 2008-10-10 04:42:28
Subject: how to invoke edtor?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group