> -----Original Message-----
> From: Tom Lane
> "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)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)
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 ?
In response to
pgsql-sql by date
|Next:||From: Anatoly K. Lasareff||Date: 2000-08-24 06:39:54|
|Subject: Re: Null function parameters|
|Previous:||From: Tom Lane||Date: 2000-08-24 05:32:45|
|Subject: Re: Create table in functions |