| From: | "H(dot) Hall" <hhall1001(at)reedyriver(dot)com> |
|---|---|
| To: | Jagadeesh <mnjagadeesh(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: can I update multiple table at a time? |
| Date: | 2008-10-10 11:07:27 |
| Message-ID: | 48EF376F.8050307@reedyriver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jordi.tablada | 2008-10-10 12:05:22 | problem running uui.sql script OSSP-UUID package |
| Previous Message | Julius Tuskenis | 2008-10-10 09:15:29 | Re: can I update multiple table at a time? |