Re: SRF_RETURN_NEXT Error: rows returned by function are not all of the same row type

From: amul sul <sul_amul(at)yahoo(dot)co(dot)in>
To: amul sul <sul_amul(at)yahoo(dot)co(dot)in>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: SRF_RETURN_NEXT Error: rows returned by function are not all of the same row type
Date: 2014-02-25 04:59:08
Message-ID: 1393304348.39355.YahooMailNeo@web193502.mail.sg3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

Hi, Finally I fixed it :)

It has issue in sub-sequence call, it looses the result store in values[]   @line 84 .
thats why, it successfully return only single row in first call and fails in further call.

It can be fix by preserving results (i.e. values[]).

Thank you !

Regards,
Amul Sul

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message JORGE MALDONADO 2014-02-25 17:20:57 Cannot establish a remote connection
Previous Message David Johnston 2014-02-25 01:26:48 Re: BYTEA: PostgreSQL 9.1 vs 9.3

Browse pgsql-sql by date

  From Date Subject
Next Message ALMA TAHIR 2014-02-27 12:23:12 Function Issue
Previous Message AlexK 2014-02-24 20:43:53 Re: Is there an upper limit on the size of an array if it is indexed?