temp tables ORACLE/PGSQL - Mailing list pgsql-general

From fisher@wckp.lodz.pl (fisher)
Subject temp tables ORACLE/PGSQL
Date
Msg-id f9c2164f.0504282230.413182ab@posting.google.com
Whole thread Raw
Responses Re: temp tables ORACLE/PGSQL  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
List pgsql-general
Hi
Thank You very much.
As I mentioned I need temp tables for storing "sesssion variables".
I plan to write functions to return suitable column value and I need
them to be availabele during whole session. That makes deleteing on
commit not the best solution. For example I want to keep emp_id in one
of columns and
use ps_get_emp_id() function to return it's value in other functions.
All values stored in thie "parameter" temp table are quite stable.

Anyway thank You very much.
fisher

pgsql-general by date:

Previous
From: Keatis
Date:
Subject: Problem: message type 0xxx arrived from server while idle
Next
From: Tom Lane
Date:
Subject: Re: Increasing statistics results in worse estimates