Help : what this Error means

[gauravgmbhr]

ERROR: returned record type does not match expected record type


HI friends

what does this error means

M not able to figure out


M calling a function that returns a record type
HERE are the values that r returned by the query executing inside the function


NOTICE: ((29,19.98,4.54,10024,50,25.59,6.31,83810))
This notice is raised inside the function


AND m calling the function
with this query


SELECT * FROM get_fund_style_details(952) AS (total_stocks INTEGER, pe_ratio numeric, pb_ratio numeric, avg_mkt_cap integer,
index_total_stocks INTEGER, index_pe_ratio numeric, index_pb_ratio numeric, index_avg_mkt_cap integer)

Which is in same order as the output shown bu notice
But still m getting the error


NOTICE: ((29,19.98,4.54,10024,50,25.59,6.31,83810))

ERROR: returned record type does not match expected record type
SQL state: 42804
Context: PL/pgSQL function "get_fund_style_details" while casting return value to function's return type



CAN SOME ONE HELP ME

[michaelb]

Please read the Posting Guidelines at the top of the forum.
You did use the CODE tags in your previous postings,
and what's this "M calling", "M not able" is about?