DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
 b=oVTzegGXt8v9pWcas4ku7YTBpdw1Rs5K3lq3Nr9urY9a403VI1QnviQLEEzEKm1u5NC8vuQuGcUtRpuNf0KYRPIxW+OBpjweZPcle10pZgMPTriRZfyzeBG0aF1+9489sfUe7zCLiqO61nAcQyHsGAxHCD9xIoA32VFdvZxvPRY=;
References: 
Message-ID: <1393224448.45554.YahooMailNeo@web193503.mail.sg3.yahoo.com>
Date: Mon, 24 Feb 2014 14:47:28 +0800 (SGT)
From: amul sul <sul_amul@yahoo.co.in>
Reply-To: amul sul <sul_amul@yahoo.co.in>
Subject: SRF_RETURN_NEXT Error: rows returned by function are not all of the
 same row type
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>,
 "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/mixed;
 boundary="1898624822-1106482902-1393224448=:45554"
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

--1898624822-1106482902-1393224448=:45554
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi ALL,

I need little help, in writing C function returns multiple row. (please fin=
d attached c code: show_eudc.c)

I have created table & inserted values in "temp" =A0as:=A0

create table temp(id int, value varchar);
insert into temp select x, lpad('string', 10, x::text)=A0from generate_seri=
es(1, 10) x;

Just want to return few rows =A0SELECT * FROM temp using C function;

While =A0setting=A0funcctx->max_calls =3D 1 work as expected; =A0

postgres=3D# select * from show_eudc();
NOTICE: =A0call_cntr : 0
=A0f1 | =A0 =A0 f2
----+------------
=A0 1 | 1111string
(1 row)

but setting=A0funcctx->max_calls =3D 2;(or 4) throws error.

NOTICE: =A0call_cntr : 0
NOTICE: =A0call_cntr : 1
ERROR: =A0rows returned by function are not all of the same row type

I am not getting cause of error, as it working for single call, but why not=
 for multiple call?

Do i missing something?

Thanks in Advance=A0


P.S. more info:

Loaded C function as:

CREATE OR REPLACE FUNCTION show_eudc(OUT f1 integer, OUT f2 varchar)
RETURNS SETOF record
AS 'MODULE_PATHNAME', 'show_eudc'
LANGUAGE C IMMUTABLE STRICT;


Regards,
Amul Sul=

--1898624822-1106482902-1393224448=:45554
Content-Type: application/octet-stream; name="show_eudc.c"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="show_eudc.c"

LyoKICogPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PQogKgogKiAgICAgICBGaWxlbmFtZTogIHRlc3QuYwogKgogKiAgICBEZXNj
cmlwdGlvbjogIGZ1bmN0aW9uIHJldHVybmluZyBtdWx0aXBsZSByb3cKICog
ICAgICAgIFZlcnNpb246ICAxLjAKICogICAgICAgIENyZWF0ZWQ6ICAwMi8x
MC8yMDE0IDAyOjUyOjIyIFBNCiAqICAgICAgIFJldmlzaW9uOiAgbm9uZQog
KiAgICAgICBDb21waWxlcjogIGdjYwogKgogKiAgICAgICAgIEF1dGhvcjog
IEFtdWwgU3VsCiAqCiAqID09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT0KICovCgojaW5jbHVkZSAicG9zdGdyZXMuaCIKI2luY2x1
ZGUgImZ1bmNhcGkuaCIKI2luY2x1ZGUgImV4ZWN1dG9yL3NwaS5oIgoKI2Rl
ZmluZSBzcWwgInNlbGVjdCAqIGZyb20gdGVtcCBsaW1pdCA0IgoKRGF0dW0g
c2hvd19ldWRjKFBHX0ZVTkNUSU9OX0FSR1MpOwoKUEdfRlVOQ1RJT05fSU5G
T19WMShzaG93X2V1ZGMpOwoKRGF0dW0Kc2hvd19ldWRjKFBHX0ZVTkNUSU9O
X0FSR1MpCnsKCUZ1bmNDYWxsQ29udGV4dCAqZnVuY2N0eDsKCWludCBjYWxs
X2NudHI7CglpbnQgbWF4X2NhbGxzOwoJCglIZWFwVHVwbGVIZWFkZXIgIHZh
bHVlc1s0XTsKCgkvKiAgU3R1ZmYgZG9uZSBvbmx5IG9uIHRoZSBmaXJzdCBj
YWxsIG9mIHRoZSBmdW5jdGlvbi4gKi8KCWlmIChTUkZfSVNfRklSU1RDQUxM
KCkpIHsKCQlNZW1vcnlDb250ZXh0IG9sZGNvbnRleHQ7CgoJCWludCByZXQs
IGk7CgkJVHVwbGVEZXNjIHR1cGRlc2M7CgkJU1BJVHVwbGVUYWJsZSAqdHVw
dGFibGUgPSBOVUxMOwoJCQoJCS8qICBjcmVhdGUgYSBmdW5jdGlvbiBjb250
ZXh0IGZvciBjcm9zcy1jYWxsIHBlcnNpc3RlbmNlICovCgkJZnVuY2N0eCA9
IFNSRl9GSVJTVENBTExfSU5JVCgpOwoJCWZ1bmNjdHgtPm1heF9jYWxscyA9
IDI7CgoJCS8qICBzd2l0Y2ggdG8gbWVtb3J5IGNvbnRleHQgYXBwcm9wcmlh
dGUgZm9yIG11bHRpcGxlIGZ1bmN0aW9uIGNhbGxzICovCgkJb2xkY29udGV4
dCA9IE1lbW9yeUNvbnRleHRTd2l0Y2hUbyhmdW5jY3R4LT5tdWx0aV9jYWxs
X21lbW9yeV9jdHgpOwoKCQlTUElfY29ubmVjdCgpOwoKCQlyZXQgPSBTUElf
ZXhlYyhzcWwsIDApOwoJCQoJCWlmIChyZXQgPT0gU1BJX09LX1NFTEVDVCkg
ewoJCQl0dXBkZXNjID0gU1BJX3R1cHRhYmxlLT50dXBkZXNjOwoJCQl0dXB0
YWJsZSA9IFNQSV90dXB0YWJsZTsKCQkJZm9yKGk9MDsgaSA8IDQ7IGkrKykK
CQkJCXZhbHVlc1tpXSA9IFNQSV9yZXR1cm50dXBsZSh0dXB0YWJsZS0+dmFs
c1tpXSwgdHVwZGVzYyk7CgkJfQoJCgkJLyogIEJ1aWxkIGEgdHVwbGUgZGVz
Y3JpcHRvciBmb3Igb3VyIHJlc3VsdCB0eXBlICovCgkJaWYgKGdldF9jYWxs
X3Jlc3VsdF90eXBlKGZjaW5mbywgTlVMTCwgJnR1cGRlc2MpICE9IFRZUEVG
VU5DX0NPTVBPU0lURSkgewoJCQllcmVwb3J0KEVSUk9SLAoJCQkJCShlcnJj
b2RlKEVSUkNPREVfRkVBVFVSRV9OT1RfU1VQUE9SVEVEKSwKCQkJCQllcnJt
c2coImZ1bmN0aW9uIHJldHVybmluZyByZWNvcmQgY2FsbGVkIGluIGNvbnRl
eHQgIgoJCQkJCQkJInRoYXQgY2Fubm90IGFjY2VwdCB0eXBlIHJlY29yZCIp
KSk7CgkJfQoKCQlNZW1vcnlDb250ZXh0U3dpdGNoVG8ob2xkY29udGV4dCk7
CgoJfS8qIEVuZCBpZihTUkZfSVNfRklSU1RDQUxMKSAqLwoKCS8qICBzdHVm
ZiBkb25lIG9uIGV2ZXJ5IGNhbGwgb2YgdGhlIGZ1bmN0aW9uICovCglmdW5j
Y3R4ID0gU1JGX1BFUkNBTExfU0VUVVAoKTsKCgljYWxsX2NudHIgPSBmdW5j
Y3R4LT5jYWxsX2NudHI7CgltYXhfY2FsbHMgPSBmdW5jY3R4LT5tYXhfY2Fs
bHM7CgoJaWYgKGNhbGxfY250ciA8IG1heF9jYWxscykgewoKCQllbG9nKE5P
VElDRSwgImNhbGxfY250ciA6ICVkIiwgY2FsbF9jbnRyKTsKCgkJU1JGX1JF
VFVSTl9ORVhUKGZ1bmNjdHgsIHZhbHVlc1tjYWxsX2NudHJdKTsKCX0gZWxz
ZSB7CgkJLyogIERvIHdoZW4gdGhlcmUgaXMgbm8gbW9yZSBsZWZ0LiAqLwoJ
CVNQSV9maW5pc2goKTsKCQlTUkZfUkVUVVJOX0RPTkUoZnVuY2N0eCk7Cgl9
IAoJCn0vKiBlbmQgc2hvd19yZXMgKi8gCg==

--1898624822-1106482902-1393224448=:45554
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

--1898624822-1106482902-1393224448=:45554--