Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 9BC1B9FA48B for ; Wed, 15 Nov 2006 02:50:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 23010-06 for ; Wed, 15 Nov 2006 06:50:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 05EBB9FA354 for ; Wed, 15 Nov 2006 02:50:09 -0400 (AST) Received: (qmail 30650 invoked by uid 500); 15 Nov 2006 06:50:48 -0000 Date: Wed, 15 Nov 2006 00:50:48 -0600 From: Bruno Wolff III To: Marko Rihtar Cc: pgsql-sql@postgresql.org Subject: Re: SQL - update table problem... Message-ID: <20061115065048.GB28693@wolff.to> Mail-Followup-To: Bruno Wolff III , Marko Rihtar , pgsql-sql@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/153 X-Sequence-Number: 26805 On Mon, Nov 13, 2006 at 11:36:05 +0100, Marko Rihtar 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.