RE: Create table in functions

> -----Original Message-----
> From: Tom Lane
>
> "Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> > Hmm,Andreas's original function seems to contain other statements.
> > If the function contains DML statements for the table Temp_Num_Table,
> > it wouldn't work properly. i.e 1st call would work but 2nd call woudn't.
>
> Are you thinking about plpgsql's caching of query plans (and
> specifically the table OIDs stored in those plans)

Yes.
We can create a table and insert into it in plpgsql functions if we
call such functions once per session(connection).
Would it be the spec of plpgsql functions in 7.1 ?

Regards.

Hiroshi Inoue