Jagadeesh 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?
Thanks
Update a view using the rule system?
See docs on rules:
http://www.postgresql.org/docs/8.3/static/rules-update.html
and this thread:
http://forums.devshed.com/postgresql-help-21/rules-views-and-updating-multiple-tables-58288.html
cheers,
HH
--
H. Hall
ReedyRiver Group LLC
http://www.reedyriver.com
