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 5064B9DCC2E for ; Fri, 27 Jan 2006 11:21:26 -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 00956-05-4 for ; Fri, 27 Jan 2006 11:21:30 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.197]) by postgresql.org (Postfix) with ESMTP id 8E82D9DCCA8 for ; Fri, 27 Jan 2006 11:21:23 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so676615nzn for ; Fri, 27 Jan 2006 07:21:28 -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=ChrtIywJIW2e9qvoaBU9Y7UyD6lSxDFV2TgtT6fvmXuDlDmBloDqivQenOLgnw+od2r2xBqKukHAiIUQzNq4k3NO1W7yTopFAxBWLT2CDOwUlORX/whaDwkMY37fdOzX+SKrV5J+d6b15WhqltjBgWxHuvNQovgABi65UEBPWkM= Received: by 10.65.75.15 with SMTP id c15mr322068qbl; Fri, 27 Jan 2006 07:21:24 -0800 (PST) Received: by 10.65.139.5 with HTTP; Fri, 27 Jan 2006 07:21:24 -0800 (PST) Message-ID: <29d3b0b90601270721g1cc4a40dib9b8ff00d953e293@mail.gmail.com> Date: Fri, 27 Jan 2006 16:21:24 +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.201 required=5 tests=[AWL=0.201] X-Spam-Score: 0.201 X-Spam-Level: X-Archive-Number: 200601/198 X-Sequence-Number: 23987 Sorry. I am working on a research prototype built on 7.3 which contains a cosiderable amount of efforts. The original developers of the prototype have no interest in upgrading it. It is also impossible for me to upgrade i= t by myself. Could you give me any tips to sovle the current problem? Thanks! 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