Edmund Kleiser wrote:
So to recap I'm creating a temp table fine.
I'm EXCUTING an insert into the temp table fine.
Then I cannot select from the table
in the form:
SELECT INTO int1 count(distinct(value)) from TEMP1;
The following creates a table, populates it and selects from it using an
EXECUTE.
I have a query surrounding somthing taht seems to have been a relatively
FAQ. It concerns the use of temporary tables in plpgsql.
Which initially resulted in the good old 'oid not found' error.
So I learnt from the maliing-list that I should be 'executing' (with EXECUTE
Command) my queries