Skip site navigation (1) Skip section navigation (2)

RE: Create table in functions

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Andreas Tille" <tillea(at)rki(dot)de>, "PostgreSQL SQL" <pgsql-sql(at)hub(dot)org>
Subject: RE: Create table in functions
Date: 2000-08-24 06:14:02
Message-ID: 000601c00d92$7fa6d480$2801007e@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-sql
> -----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)

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


In response to

pgsql-sql by date

Next:From: Anatoly K. LasareffDate: 2000-08-24 06:39:54
Subject: Re: Null function parameters
Previous:From: Tom LaneDate: 2000-08-24 05:32:45
Subject: Re: Create table in functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group