By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,501 Members | 2,790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,501 IT Pros & Developers. It's quick & easy.

Help : what this Error means

gauravgmbhr
100+
P: 107
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
Apr 10 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 534
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?
Apr 10 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.