temp tables ORACLE/PGSQL

Поиск
Список
Период
Сортировка
От fisher@wckp.lodz.pl (fisher)
Тема temp tables ORACLE/PGSQL
Дата
Msg-id f9c2164f.0504282230.413182ab@posting.google.com
обсуждение исходный текст
Ответы Re: temp tables ORACLE/PGSQL  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Список 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 по дате отправления:

Предыдущее
От: Keatis
Дата:
Сообщение: Problem: message type 0xxx arrived from server while idle
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Increasing statistics results in worse estimates