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

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

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.