X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2209B14B281B for ; Wed, 11 Aug 2004 11:41:38 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12983-08 for ; Wed, 11 Aug 2004 14:41:36 +0000 (GMT) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.192]) by svr1.postgresql.org (Postfix) with ESMTP id 49A7214B280B for ; Wed, 11 Aug 2004 11:41:33 -0300 (ADT) Received: by mproxy.gmail.com with SMTP id 73so177503rnk for ; Wed, 11 Aug 2004 07:41:37 -0700 (PDT) Received: by 10.38.181.19 with SMTP id d19mr468111rnf; Wed, 11 Aug 2004 07:41:37 -0700 (PDT) Message-ID: <37d451f7040811074179008664@mail.gmail.com> Date: Wed, 11 Aug 2004 09:41:37 -0500 From: Rosser Schwarz To: Philippe Lang Subject: Re: function expression in FROM may not refer to other relations of same query level Cc: pgsql-sql@postgresql.org In-Reply-To: <6C0CF58A187DA5479245E0830AF84F420803B4@poweredge.attiksystem.ch> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <6C0CF58A187DA5479245E0830AF84F420803B4@poweredge.attiksystem.ch> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/86 X-Sequence-Number: 18583 Philippe Lang wrote: > The problem now is that get_lines is being called twice per line. Is get_lines() defined as IMMUTABLE? Should it be? /rls -- :wq