| From: | Brandon E Hofmann <Brandon_E_Hofmann(at)notes(dot)ntrs(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Temp Tables |
| Date: | 2006-05-25 12:42:06 |
| Message-ID: | OF7FC9E57C.53F0302D-ON86257179.0044F15D-86257179.0045D770@notes.ntrs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Volkan YAZICI | 2006-05-25 13:09:48 | Re: postgreslog - panic message |
| Previous Message | CG | 2006-05-25 12:41:21 | Postmaster crashes after upgrade to 8.1.4! |