Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id D4E4C9FA219 for ; Mon, 13 Nov 2006 06:36:11 -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 36640-02 for ; Mon, 13 Nov 2006 10:36:08 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from bay0-omc3-s23.bay0.hotmail.com (bay0-omc3-s23.bay0.hotmail.com [65.54.246.223]) by postgresql.org (Postfix) with ESMTP id E1F7A9FA158 for ; Mon, 13 Nov 2006 06:36:07 -0400 (AST) Received: from hotmail.com ([207.46.10.86]) by bay0-omc3-s23.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 13 Nov 2006 02:36:05 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 13 Nov 2006 02:36:05 -0800 Message-ID: Received: from 207.46.10.123 by by121fd.bay121.hotmail.msn.com with HTTP; Mon, 13 Nov 2006 10:36:05 GMT X-Originating-IP: [213.147.99.126] X-Originating-Email: [riki_fox@hotmail.com] X-Sender: riki_fox@hotmail.com From: "Marko Rihtar" To: pgsql-sql@postgresql.org Subject: SQL - update table problem... Date: Mon, 13 Nov 2006 11:36:05 +0100 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 13 Nov 2006 10:36:05.0733 (UTC) FILETIME=[85FEF150:01C7070F] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.722 tagged_above=0 required=5 tests=BAYES_40, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: * X-Archive-Number: 200611/120 X-Sequence-Number: 26772 Hi, first i'm sorry if this message appears twice. first time didn't get through because i wasn't registered. i'm trying to do update on multiple tables but don't know how. is something like this posible with postgresql? update table1 join table2 on (table1.id=table2.t1) join table3 on (table2.id=table3.t2) set table1.name='test', table2.sum=table1.x+table2.y, table3.cell='123456789' where table1.id=6 i know that this syntax is not supported with postgres but i tried to rewrite the code using this synopsis: UPDATE [ ONLY ] table SET column = { expression | DEFAULT } [, ...] [ FROM fromlist ] [ WHERE condition ] i failed again. thanks for help _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/