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 3986C9DC967 for ; Fri, 27 Jan 2006 12:32:17 -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 15274-03 for ; Fri, 27 Jan 2006 12:32:14 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.200]) by postgresql.org (Postfix) with ESMTP id 1F3509DC88C for ; Fri, 27 Jan 2006 12:32:13 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so698222nzn for ; Fri, 27 Jan 2006 08:32:13 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=HpqW+SHQsdUobtMRVmmJbBUREqB+JoiPFBj5rrgTfUTr528oM7xiFNvCO1h9NJoa3eHBUPVYY6lmzg4LA8mPgtxzXL5QsYn3Medua1tUPyU+YEX4LX86NLX0I9WEQrM7xFw3/2V96FJgaxfh66QMJDKOBH5XItMtb3GTTZvLnfM= Received: by 10.65.224.13 with SMTP id b13mr429073qbr; Fri, 27 Jan 2006 08:32:13 -0800 (PST) Received: by 10.65.139.5 with HTTP; Fri, 27 Jan 2006 08:32:13 -0800 (PST) Message-ID: <29d3b0b90601270832l576b2768t493736a4cc4c88fe@mail.gmail.com> Date: Fri, 27 Jan 2006 17:32:13 +0100 From: andrew To: pgsql-sql@postgresql.org Subject: Re: filtering after join In-Reply-To: <2048.1138373739@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <29d3b0b90601250927o2a5ee6e6mc33a7647da4438ce@mail.gmail.com> <200601261222.34906.peter_e@gmx.net> <29d3b0b90601260454g35817213o7d5a0e8a1e53ddf7@mail.gmail.com> <200601261759.31184.peter_e@gmx.net> <29d3b0b90601270110w645eab52k41ea6e385f297ae4@mail.gmail.com> <29d3b0b90601270117t2a8ec180x469b2a65f6b29a13@mail.gmail.com> <2048.1138373739@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.198 required=5 tests=[AWL=0.198] X-Spam-Score: 0.198 X-Spam-Level: X-Archive-Number: 200601/199 X-Sequence-Number: 23988 I have traced the code. It exits when the argument is the result of a join or a subselect in function ParseFuncOrColumn(). The reason mentioned in the comments is lack of named tuple type. How can force it to create such a tuple type? is there a way? thanks a million times! On 1/27/06, Tom Lane wrote: > andrew writes: > > I got errors in this query. I have a function complete(record) which > > takes a generic record type data. But it seems cannot be applied to a > > sub-select result: > > As I seem to recall having mentioned several times already, PG 7.3 is > really, really weak in this area. (If you ever got it to work, which > I doubt you will, you'd probably then start to notice how badly it > leaks memory for whole-row operations...) > > You should either forget this idea or invest the effort to move up > to PG 8.1. > > regards, tom lane > -- andrew