X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 42AC39DC87B for ; Thu, 15 Dec 2005 11:33:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22443-10 for ; Thu, 15 Dec 2005 11:33:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp3.libero.it (smtp3.libero.it [193.70.192.127]) by postgresql.org (Postfix) with ESMTP id 874629DC807 for ; Thu, 15 Dec 2005 11:33:40 -0400 (AST) Received: from localhost (172.16.1.84) by smtp3.libero.it (7.0.027-DD01) id 439D911000564A20 for pgsql-sql@postgresql.org; Thu, 15 Dec 2005 16:33:44 +0100 Received: from smtp2.libero.it ([172.16.1.97]) by localhost (asav5.libero.it [193.70.192.154]) (amavisd-new, port 10024) with ESMTP id 07846-05-5 for ; Thu, 15 Dec 2005 16:33:42 +0100 (CET) Received: from [172.16.0.5] (ppp-25-210.24-151.libero.it [151.24.210.25]) by smtp2.libero.it (Postfix) with ESMTP id 6396AA8C36 for ; Thu, 15 Dec 2005 16:33:42 +0100 (MET) Message-ID: <43A18D46.6060201@moonwatcher.it> Date: Thu, 15 Dec 2005 16:35:34 +0100 From: Gianluca Riccardi User-Agent: Mozilla/5.0 (X11; U; Linux i686; it-IT; rv:1.7.8) Gecko/20050927 Debian/1.7.8-1sarge3 X-Accept-Language: it MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: selective updates References: <43A18658.8030202@moonwatcher.it> In-Reply-To: <43A18658.8030202@moonwatcher.it> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Scanned: with antispam and antivirus automated system at libero.it X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/130 X-Sequence-Number: 23672 Gianluca Riccardi wrote: [cut] solved, i used a function giving as result the wanted value from table2.column1 in a UPDATE table1 SET column4=(my_personal_func()) WHERE 'cirteria on table1.column2 table2.column2' ; sorry for making you wasting your time Gianluca Riccardi