Re: SQL - update table problem... - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: SQL - update table problem...
Date
Msg-id 20061115065048.GB28693@wolff.to
Whole thread Raw
In response to SQL - update table problem...  ("Marko Rihtar" <riki_fox@hotmail.com>)
List pgsql-sql
On Mon, Nov 13, 2006 at 11:36:05 +0100, Marko Rihtar <riki_fox@hotmail.com> wrote:
> 
> i'm trying to do update on multiple tables but don't know how.
> is something like this posible with postgresql?

I believe you need to use multiple update statements to do this. Each
update can only update one table. You can join with other tables to
select which rows to update, but that doesn't let you update more than
one table at once.


pgsql-sql by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: unexpected EOF within message length word
Next
From: Luca Ferrari
Date:
Subject: sql problem with join