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

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