Incorrect tuple result but correct answer

30 views
Skip to first unread message

Theruni Pethiyagoda

unread,
May 23, 2018, 5:24:10 AM5/23/18
to COMP9311 Project Q&A

Any particular reason why I have the correct answer but when I check with the check_q3() I get incorrect result tuples error. 

I called another function that gave the result using:

Return query select * from final_q3(org_id, num_courses, min_score);

RETURN;

END;

$body$

LANGUAGE plpgsql;


and I have used return setof courserecord. I dont really know how else to check whats wrong here. Any help would be appreciated!



Screen Shot 2018-05-23 at 7.15.50 PM.png

Paula Kiatkamolwong

unread,
May 23, 2018, 6:43:38 AM5/23/18
to COMP9311 Project Q&A
I think you need an extra E'\n' at the end of each student's last subject. If you look at the provided Project2 pdf file, in the picture there's an extra blank line at the end of tuple Nye Cavallo, a blank line at the end of Ningbo Su, and also Nicholas Barry. 

Theruni Pethiyagoda

unread,
May 23, 2018, 8:09:32 AM5/23/18
to COMP9311 Project Q&A
Thank you so much! It worked!
Reply all
Reply to author
Forward
0 new messages