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? 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.

Any help would be greatly appreciated.

Thanks,

Brandon


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster