> 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?
Update a view using the rule system?
See docs on rules:
and this thread:
ReedyRiver Group LLC
In response to
pgsql-admin by date
|Next:||From: jordi.tablada||Date: 2008-10-10 12:05:22|
|Subject: problem running uui.sql script OSSP-UUID package|
|Previous:||From: Julius Tuskenis||Date: 2008-10-10 09:15:29|
|Subject: Re: can I update multiple table at a time?|