Thanks for your response, but it doesn't change anything with or without the 'RETURNS record', in fact, if I don't specify it, when I look at the function in the database (through pgAdmin III), it automatically adds the 'RETURNS record' statement.
What am I doing wrong?
Is it right to use the SELECT INTO in the other function to get the out parameters?
You bet. I just saw this trick and thought I'd share:
SELECT (testmultoutfunct('TT','1')).* INTO vStatus, vId
This isn't a feature I use too often, but it is handy when you've got complex calculations and need to return x,y coordinates or min, max etc. But if you want to see a bunch of people get their panties in knot, ask this question on an Oracle forum. LOL.
I'm not sure why they get offended. Maybe they're upset their expensive db can't do something that a free db does.