Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 192E89FB438 for ; Sun, 11 Feb 2007 17:52:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 72745-08 for ; Sun, 11 Feb 2007 17:52:09 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.188]) by postgresql.org (Postfix) with ESMTP id AEACC9FB2CE for ; Sun, 11 Feb 2007 17:52:11 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so1928962nfb for ; Sun, 11 Feb 2007 13:52:10 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=L5gvZB33KB0DHtZGIc5vP2pBJMCEqboI6Mm6BRT7a4hqe9bf8LQCWNP03RsTpBvxJlyBb2QYFwEsf07je1rD3I8tsuN/Sa6ByChs0A03Gc6cosbuEtjAAfmwd/IvyDG2uKPHYb0UqaMyxWVbpoECtlToaUio5LLvRLGtBUN0heA= Received: by 10.82.152.16 with SMTP id z16mr8689854bud.1171230730164; Sun, 11 Feb 2007 13:52:10 -0800 (PST) Received: by 10.82.183.4 with HTTP; Sun, 11 Feb 2007 13:52:10 -0800 (PST) Message-ID: <1f30b80c0702111352q73c8a10do2fcb672e98b9e5b4@mail.gmail.com> Date: Mon, 12 Feb 2007 02:52:10 +0500 From: imad To: "Robert Wimmer" Subject: Re: temporary table / recursion Cc: pgsql-interfaces@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1f30b80c0702111305m7c04ffe4hbb58d780561eb606@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.119 tagged_above=0 required=5 tests=AWL, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/15 X-Sequence-Number: 6435 On 2/12/07, Robert Wimmer wrote: > dear imad, > > thank you very much for your help and your patience. after "executing" > really every statement it works. even the FOR tmp IN statement has to be > "executed" Good to see this. --Imad www.EnterpriseDB.com