When using a temp table in plpgsql functions that has columns comprised from many tables populated by joins, how do you specify a temp table return type when its generated by select into and dropped dynamically? I get an error when I specify returns setof temp_table. Also when I specify a permanent table as the return type, I get extra blank columns in the result set which are the additional columns of the permanent table I don't need and the data is displayed in the wrong columns. I tried defining composite types, but get a runtime error that it isn't available unless I first define it outside of the function. Since requests are dynamic, its impossible for me to determine all possible composite types required ahead of time. In plpgsql, how do you return back a result set that is determined and generated at runtime based on a report request? Also why does plpgsql require you to define what is returned? I'm relatively new to PostgreSQL and really impressed by its capabilities. Do you have any examples showing how to define and return a dynamic result set at runtime within a function? Any help would be greatly appreciated. Thanks, Brandon
