Skip site navigation (1) Skip section navigation (2)

Re: can I update multiple table at a time?

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 (view raw or flat)
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


In response to

pgsql-admin by date

Next:From: jordi.tabladaDate: 2008-10-10 12:05:22
Subject: problem running uui.sql script OSSP-UUID package
Previous:From: Julius TuskenisDate: 2008-10-10 09:15:29
Subject: Re: can I update multiple table at a time?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group