Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WIA6u-0001eL-HM for pgsql-novice@arkaria.postgresql.org; Tue, 25 Feb 2014 04:59:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WIA6t-0002nO-Sp for pgsql-novice@arkaria.postgresql.org; Tue, 25 Feb 2014 04:59:15 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WIA6s-0002nA-HC for pgsql-novice@postgresql.org; Tue, 25 Feb 2014 04:59:14 +0000 Received: from nm16-vm7.bullet.mail.sg3.yahoo.com ([106.10.149.70]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WIA6p-0003ef-3g for pgsql-novice@postgresql.org; Tue, 25 Feb 2014 04:59:13 +0000 Received: from [106.10.166.62] by nm16.bullet.mail.sg3.yahoo.com with NNFMP; 25 Feb 2014 04:59:08 -0000 Received: from [106.10.150.23] by tm19.bullet.mail.sg3.yahoo.com with NNFMP; 25 Feb 2014 04:59:08 -0000 Received: from [127.0.0.1] by omp1024.mail.sg3.yahoo.com with NNFMP; 25 Feb 2014 04:59:08 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 311233.18104.bm@omp1024.mail.sg3.yahoo.com Received: (qmail 94901 invoked by uid 60001); 25 Feb 2014 04:59:08 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s1024; t=1393304348; bh=NXIOxUl1Xqe6EtvcZg4k6JfpuVd6pQO4s3Jq5oQ1BC0=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=0KNaopwX5FHi7rObX5+k3tln84tr7Jr/7/3586hu2ybqPG+m7/mnKPEi4C++QJmiqssvLFUoeBUIPPUdkclfjK8cpttTfNswwKuFf77JAhZjnx1Qxhq1kJZAIlrscFmBCLEk3Fdb2ZCoAyr3r+/lHMdrHgK9PrVjUn1fpIRdTsw= 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:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=AlT89oSRJ9TeNHZ5AHiiiCf3zWYjRx2ie9dCJS9eXKyutetfMLQ1iCp1re1PkpMFnMYNCzcYNG0wetIM58VIWt2s2nsDvYts6lhzzBfcAlEb9C1cbJYes5YoNNbLiFTXqv3pXLY8vcc2neV7LlLp2HnSSF7gRcGUZW6kk2frroY=; X-YMail-OSG: O0RcyEoVM1nMY7ziww8WCE_tbEydSw0ZXsfdHRWLZrlmHAF h1xS2KTvjc2NpPKjnMAknFM18vukIfwOLQsBDU8kfOk5xFxhsgdc_KzMQxnw sUq7wn3iT72oo5KoTN5Gfe5hl8TMPBJfzeQs_UHEXz4msyoYIABBgNMAR4ai FmxTOHBav.DUTfCQ8Rb46T0f5fMnRVtWum5lbhDMVZ7jkwlaTip7EAWyRlJ8 Oydgny8qFvD0OQBS4FoGorSymJcx1B_ZPuUwick98.Q.DXhpsfpsotff36vl Ytu6MqC9HqWgrphIlufwU09TDTRJiuQWlKjyCy.2hYUpmgQq_WrwE_2uTLH8 489gmMl0re8QSUDc14Jt6SYNharHCdjC8xqSF3vf3FO5hmJSXxEkyBgGx1rX 7Z5oKycE2EUtuAi6GJJU8UCWNx3RssGUzlsMiw8jfLAZGA9gyAXEAK9uUTzj lgphORXXI.gn3n5kOD_ObphJe0paM39f6GuGUyXZ0kTXqIe5mYNOk8yo2Vxp h1UKsaNeVQOWeppy_dzrDIitk5ZYlkhH324SFKRmNUbHV Received: from [129.60.57.66] by web193502.mail.sg3.yahoo.com via HTTP; Tue, 25 Feb 2014 12:59:08 SGT X-Rocket-MIMEInfo: 002.001, CgpIaSwgRmluYWxseSBJIGZpeGVkIGl0IDopCgpJdCBoYXMgaXNzdWUgaW4gc3ViLXNlcXVlbmNlIGNhbGwsIGl0IGxvb3NlcyB0aGUgcmVzdWx0IHN0b3JlIGluIHZhbHVlc1tdIMKgIEBsaW5lIDg0IC4KdGhhdHMgd2h5LCBpdCBzdWNjZXNzZnVsbHkgcmV0dXJuIG9ubHkgc2luZ2xlIHJvdyBpbiBmaXJzdCBjYWxsIGFuZCBmYWlscyBpbiBmdXJ0aGVyIGNhbGwuCgpJdCBjYW4gYmUgZml4IGJ5IHByZXNlcnZpbmcgcmVzdWx0cyAoaS5lLiB2YWx1ZXNbXSkuCgpUaGFuayB5b3UgIQoKUmVnYXJkcywKQW11bCABMAEBAQE- X-Mailer: YahooMailWebService/0.8.177.636 References: <1393224448.45554.YahooMailNeo@web193503.mail.sg3.yahoo.com> Message-ID: <1393304348.39355.YahooMailNeo@web193502.mail.sg3.yahoo.com> Date: Tue, 25 Feb 2014 12:59:08 +0800 (SGT) From: amul sul Reply-To: amul sul Subject: Re: SRF_RETURN_NEXT Error: rows returned by function are not all of the same row type To: amul sul , "pgsql-sql@postgresql.org" , "pgsql-novice@postgresql.org" In-Reply-To: <1393224448.45554.YahooMailNeo@web193503.mail.sg3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: 0.7 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-novice Precedence: bulk Sender: pgsql-novice-owner@postgresql.org Hi, Finally I fixed it :) It has issue in sub-sequence call, it looses the result store in values[] = =A0 @line 84 . thats why, it successfully return only single row in first call and fails i= n further call. It can be fix by preserving results (i.e. values[]). Thank you ! Regards, Amul Sul --=20 Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-novice