I read somewhere that you could have a table as a return type. I, therefore tried using the pivot table alias as the return type but got an error along lines of the alias not being recognized.
A table in that context is something you create using the "Create table" command. And, per my other comments, you have to have done this before even creating the function in question since the function has to point to the table during the "create function" command's execution.