X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 40D189FB286 for ; Tue, 19 Sep 2006 17:44:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 08616-09 for ; Tue, 19 Sep 2006 20:43:42 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id BB3BC9FB273 for ; Tue, 19 Sep 2006 17:43:41 -0300 (ADT) Received: (qmail invoked by alias); 19 Sep 2006 20:43:38 -0000 Received: from dslb-084-057-016-185.pools.arcor-ip.net (EHLO ltmku) [84.57.16.185] by mail.gmx.net (mp041) with SMTP; 19 Sep 2006 22:43:38 +0200 X-Authenticated: #23352258 From: "Milen Kulev" To: Subject: Pipelined functions in Postgres Date: Tue, 19 Sep 2006 22:43:33 +0200 Message-ID: <005701c6dc2c$49011fc0$0a00a8c0@trivadis.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Importance: Normal X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200609/257 X-Sequence-Number: 20943 Hello Lister, I am curios whether I can emulate the Oracle pipelined functions functionality in PG too (using RETURN NEXT ). For more information and examples about Oracle pipelined functions see: http://asktom.oracle.com/pls/ask/f?p=4950:8:8127757633768425921::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:4447489221109 I have used pipeline functions in DWH enviromnent with success and would like To use similar concept in PG too. Any help, examples , links and shared experiences would be greately appreciated. Best Regards. Milen