Date: Wed, 21 May 2025 17:23:36 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Michael Paquier <michael@paquier.xyz>,
	Peter Eisentraut <peter@eisentraut.org>,
	Marcos Pegoraro <marcos@f10.com.br>,
	jian he <jian.universality@gmail.com>,
	Dmitry Dolgov <9erthalion6@gmail.com>,
	Laurenz Albe <laurenz.albe@cybertec.at>,
	Erik Rijkers <er@xs4all.nl>, Amit Kapila <amit.kapila16@gmail.com>,
	DUVAL REMI <REMI.DUVAL@cheops.fr>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Re: proposal: schema variables
Message-ID: <aC5EWCc8bH7FmeXj@momjian.us>
References: 
 <CAFj8pRArtw+Qqzk+Zf2NxjgO=paCBdc54eEma+MsVwtx3j7Atg@mail.gmail.com>
 <CAFj8pRAK_8ym1J=SAdin-vtL0PAachXgjWgU3QrhzinRdBX2sw@mail.gmail.com>
 <CAFj8pRAx-Gb9Ux825cxGNm38qQUOrij1GY6erPRaQ=cpqfiX7g@mail.gmail.com>
 <CAFj8pRCEjG005L=1vGbir-odYdcYxByOAeFVJ_K9eRcRF=MbNQ@mail.gmail.com>
 <aCyYHXhAjXOUPvLO@momjian.us>
 <CAB-JLwY2-Hm_SYbj2td_VKuU8awCwgDr-sOtjHRE2C-Sgg_pFg@mail.gmail.com>
 <aCywNzDx2J3jrY1-@momjian.us>
 <CAFj8pRABfnPMJCzqLKp11q-FhpdteTcAG8Bqm6SOoe-RA2uxcA@mail.gmail.com>
 <aC0clv2F-HR1vVvP@paquier.xyz>
 <CAFj8pRChvU6-ANJD_G=3+zfou-ADu05oxfCnbXFgtQhyWMggwg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAFj8pRChvU6-ANJD_G=3+zfou-ADu05oxfCnbXFgtQhyWMggwg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/aC5EWCc8bH7FmeXj%40momjian.us>
Precedence: bulk

On Wed, May 21, 2025 at 07:49:34AM +0200, Pavel Stehule wrote:
> st 21. 5. 2025 v 2:21 odesílatel Michael Paquier <michael@paquier.xyz> napsal:
>     One thing that I keep hearing about this feature is that this would be
>     really helpful for migration from Oracle to PostgreSQL, helping a lot
>     with rewrites of pl/pgsql functions.
> 
>     There is one page on the wiki about private variables, dating back to
>     2016:
>     https://wiki.postgresql.org/wiki/CREATE_PRIVATE_VARIABLE
> 
> I wrote mail 
> 
> https://www.postgresql.org/message-id/
> CAFj8pRB8kdWQCdN2X1_63c58+07Oy4Z+ruDK_xPTUP+Pe8R2Pw@mail.gmail.com
> 
> and there is another wiki page https://wiki.postgresql.org/wiki/Variable_Design

Yes, these URLs are very helpful, thanks.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.