On Thu, 9 Oct 2008 22:12:04 -0700 (PDT)
Jagadeesh <mnjagadeesh(at)gmail(dot)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?
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
In response to
pgsql-admin by date
|Next:||From: Julius Tuskenis||Date: 2008-10-10 06:06:18|
|Subject: Re: can I update multiple table at a time?|
|Previous:||From: Jagadeesh||Date: 2008-10-10 05:12:04|
|Subject: can I update multiple table at a time?|