Matthew Peter wrote:
Is there any way to use CREATE TYPE or an VIEW/TABLE defintion list instead of manually defining it?
Yes, just define your function as returning that type rather than RECORD. That way the calling context will know what to expect.
-- Richard Huxton Archonet Ltd