Postgres Pro
Downloads
Home   >   mailing lists

Re: [NOVICE] SRF_RETURN_NEXT Error: rows returned by function are not all of the same row type - Mailing list pgsql-sql

From amul sul
Subject Re: [NOVICE] SRF_RETURN_NEXT Error: rows returned by function are not all of the same row type
Date
Msg-id 1393304348.39355.YahooMailNeo@web193502.mail.sg3.yahoo.com
Whole thread Raw
In response to SRF_RETURN_NEXT Error: rows returned by function are not all of the same row type  (amul sul <sul_amul@yahoo.co.in>)
List pgsql-sql
Tree view 

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

pgsql-sql by date:

Previous
From: AlexK
Date:
Subject: Re: Is there an upper limit on the size of an array if it is indexed?
Next
From: ALMA TAHIR
Date:
Subject: Function Issue