Quick Links

can I update multiple table at a time?

From:	Jagadeesh <mnjagadeesh(at)gmail(dot)com>
To:	pgsql-admin(at)postgresql(dot)org
Subject:	can I update multiple table at a time?
Date:	2008-10-10 05:12:04
Message-ID:	4ba626d0-b2b5-4421-8df1-1bb39d4a858b@t39g2000prh.googlegroups.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

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

Responses

Re: can I update multiple table at a time? at 2008-10-10 05:53:51 from Joshua Drake
Re: can I update multiple table at a time? at 2008-10-10 06:06:18 from Julius Tuskenis
Re: can I update multiple table at a time? at 2008-10-10 11:07:27 from H. Hall
Re: can I update multiple table at a time? at 2008-10-10 13:18:29 from Igor Neyman

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Joshua Drake	2008-10-10 05:53:51	Re: can I update multiple table at a time?
Previous Message	Jagadeesh	2008-10-10 04:42:28	how to invoke edtor?