Re: Postgres Equivalent of Oracle Package
От
DAVID ROTH
Тема
Re: Postgres Equivalent of Oracle Package
Дата
Msg-id
578672982.410788.1637092296124@connect.xfinity.com
Ответ на
Re: Postgres Equivalent of Oracle Package (Pavel Stehule)
Список
Дерево обсуждения
How is JSON stored in PG ? David Gauthier <davegauthierpg@gmail.com>
Re: How is JSON stored in PG ? Ray O'Donnell <ray@rodonnell.ie>
Postgres Equivalent of Oracle Package DAVID ROTH <adaptron@comcast.net>
Re: Postgres Equivalent of Oracle Package Mladen Gogala <gogala.mladen@gmail.com>
Re: Postgres Equivalent of Oracle Package Pavel Stehule <pavel.stehule@gmail.com>
Re: Postgres Equivalent of Oracle Package DAVID ROTH <adaptron@comcast.net>
Re: Postgres Equivalent of Oracle Package Pavel Stehule <pavel.stehule@gmail.com>
Re: How is JSON stored in PG ? Laurenz Albe <laurenz.albe@cybertec.at>
Re: How is JSON stored in PG ? Adrian Klaver <adrian.klaver@aklaver.com>
I can see how schemas can be used to keep related tables and other object together. I may be missing something but I don't see how they can be used to emulate the "once-per-session" behavior of Oracle packages. Have I missed something?
On 11/16/2021 12:27 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:Hiút 16. 11. 2021 v 18:23 odesílatel DAVID ROTH <adaptron@comcast.net> napsal:One of the nice things about Oracle packages is that the code is loaded and global values are set and stored only once per session. This is very useful for values that are used repeatedly.
What is the best way of emulating this behavior in Postgresql?you can use a schemas - you can see it in OrafceRegardsPavel
В списке pgsql-general по дате отправления
