Re: SQL - update table problem...

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Marko Rihtar <riki_fox(at)hotmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL - update table problem...
Date: 2006-11-15 06:50:48
Message-ID: 20061115065048.GB28693@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Nov 13, 2006 at 11:36:05 +0100,
Marko Rihtar <riki_fox(at)hotmail(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Luca Ferrari 2006-11-15 08:32:04 sql problem with join
Previous Message Richard Broersma Jr 2006-11-14 21:52:47 Re: unexpected EOF within message length word