Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id DDCEF13574FC for ; Mon, 7 Nov 2011 16:22:00 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 14411-02-5 for ; Mon, 7 Nov 2011 20:21:51 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com [209.85.212.46]) by mail.postgresql.org (Postfix) with ESMTP id 8CAD3BBC94 for ; Mon, 7 Nov 2011 16:15:26 -0400 (AST) Received: by vws1 with SMTP id 1so3986479vws.19 for ; Mon, 07 Nov 2011 12:15:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; bh=mr1+JYtoV7Sr1CJI96JkeZ0a4FDEK+nG2dqTDnZHum0=; b=KnvwtD5gbGCJpTGeusCHNw/FTULIwZIQOsPtC3okNpK/rm+gd/iHW+Zc7F2uBV86TE uSYjIZjGoSzYQVJyG87fWx95Px31LyvtBTjtOuxwvZZ7TccmglHWeKuE9efqH3Q09fZe 67AlQH5BPSDBrc81gH3kvAs1k2C3IbFG3NUF8= Received: by 10.52.98.129 with SMTP id ei1mr28259966vdb.50.1320696925970; Mon, 07 Nov 2011 12:15:25 -0800 (PST) Received: from jay.local (c-24-63-250-125.hsd1.ma.comcast.net. [24.63.250.125]) by mx.google.com with ESMTPS id c7sm31672384vdh.12.2011.11.07.12.15.24 (version=SSLv3 cipher=OTHER); Mon, 07 Nov 2011 12:15:25 -0800 (PST) Message-ID: <4EB83C5B.3020103@gmail.com> Date: Mon, 07 Nov 2011 15:15:23 -0500 From: Jay Levitt User-Agent: Postbox 3.0.1 (Macintosh/20111102) MIME-Version: 1.0 To: Tom Lane CC: pgsql-performance@postgresql.org Subject: Re: Predicates not getting pushed into SQL function? References: <4EB2D3CB.7020708@gmail.com> <6646.1320345676@sss.pgh.pa.us> <4EB2E251.90906@gmail.com> <11061.1320352516@sss.pgh.pa.us> <4EB83BF7.4070905@gmail.com> In-Reply-To: <4EB83BF7.4070905@gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001 X-Spam-Level: X-Archive-Number: 201111/97 X-Sequence-Number: 45608 Jay Levitt wrote: > Yes, that patch works great! Oddly enough, the workaround now does NOT work; > functions returning SETOF named composite types don't get inlined, but > functions returning the equivalent TABLE do get inlined. Let me know if you > need a failcase, but the bug doesn't actually affect me now :) Never mind... I left a "strict" in my test. Works great all around.