> > Create the temp table only once per connection (you can use ON COMMIT
> > DELETE ROWS instead of ON COMMIT DROP to clean it out). Then you won't
> > need to use EXECUTE.
> >
I am sorry, first time I didn't understand. Now I did some test and its
good adivice. Sometimes I have problem understand so I can use temp.
tables on an level of connection and its not neccesery push temp tables on
SP level. If I don't change structure of temp tables (and its unpropably
on produstion database) I haven't problems. I have still one question.
What is possible so I can
CREATE OR REPLACE FONCTION foo() ..
BEGIN CREATE TEMP TABLE xxx(...
INSERT INTO xxx VALUES (...
It's works, but in time of compilation SP temp table xxx doesn't exists.
It's mean so Id in cmd INSERT is little bit dynamic?
I rewrite my SP and I have one notice: In documentation is note, so
TRUNCATE TABLE is faster then DELETE FROM. It's not true for small temp
tables. On my computer TRUNCATE needs 100ms and DELETE 8ms. It's general
or any exception?
Thank You
Pavel Stehule
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
