On Tue, 2006-09-19 at 23:22 +0200, Milen Kulev wrote:
> Hello Shoaib,
> I know the SETOF funcitons. I want to simulate (somehow)
> producer/consumer relationship with SETOF(pipelined) functions. The
> first (producer )function generates records (just like your test_pipe
> function), and the seco
I dont think so that will be possible using SETOF function ...You might have to partition the current query and this way can distribute the full load of the query if there is too much data invovled.Thanks,
-- Shoaib MirEnterpriseDB (www.enterprisedb.com)On 9/20/06, Milen Kulev <
[EMAIL PROTECTED]>
ext record.
Regards,
Milen
-Original Message-From: Talha Khan
[mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006
11:08 PMTo: Milen KulevCc:
pgsql-performance@postgresql.orgSubject: Re: [PERFORM] Pipelined
functions in Postgres
Hi Milen,
Pipeli
Title: Nachricht
Hello
Shoaib,
I know
the SETOF funcitons. I want to simulate (somehow) producer/consumer
relationship with SETOF(pipelined) functions. The first
(producer )function generates records (just like your test_pipe function),
and the second function consumers the records , pro
Hi Milen,
Pipelined function is a code that acts like a database table.
Inorder to use this functionality in postgres you would need to write the function like this
CREATE OR REPLACE FUNCTION get_test_data (numeric) RETURNS SETOF RECORD AS$$DECLARE temp_rec RECORD;BEGIN FOR temp_r
I think pipelined functions are code you can pretend is a database table.
For example you can do it like this in Oracle:
select * from PLSQL_FUNCTION;You can achieve something similar in PostgreSQL using RETURN SETOF functions like this:
CREATE OR REPLACE FUNCTION test_pipe (int)
RETURNS SETO
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_CRI
