Re: can I update multiple table at a time? - Mailing list pgsql-admin

From Joshua Drake
Subject Re: can I update multiple table at a time?
Date
Msg-id 20081009225351.0ccdaa3b@jd-laptop
Whole thread Raw
In response to can I update multiple table at a time?  (Jagadeesh <mnjagadeesh@gmail.com>)
List pgsql-admin
On Thu, 9 Oct 2008 22:12:04 -0700 (PDT)
Jagadeesh <mnjagadeesh@gmail.com> wrote:

> 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?

Use a transaction?

>
> Thanks
>


--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/



pgsql-admin by date:

Previous
From: Jagadeesh
Date:
Subject: can I update multiple table at a time?
Next
From: Julius Tuskenis
Date:
Subject: Re: can I update multiple table at a time?