Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-novice-owner+archive@lists.postgresql.org>)
	id 1m5XtH-0007xF-7n
	for pgsql-novice@arkaria.postgresql.org; Mon, 19 Jul 2021 18:21:19 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-novice-owner+archive@lists.postgresql.org>)
	id 1m5Xsk-0007xE-Fq
	for pgsql-novice@arkaria.postgresql.org; Mon, 19 Jul 2021 18:20:46 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <adaptron@comcast.net>)
	id 1m5Xsj-0007x5-SC
	for pgsql-novice@lists.postgresql.org; Mon, 19 Jul 2021 18:20:46 +0000
Received: from resqmta-ch2-02v.sys.comcast.net
 ([2001:558:fe21:29:69:252:207:34])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <adaptron@comcast.net>)
	id 1m5Xsf-0004Ek-KV
	for pgsql-novice@lists.postgresql.org; Mon, 19 Jul 2021 18:20:44 +0000
Received: from resomta-ch2-17v.sys.comcast.net ([69.252.207.113])
	by resqmta-ch2-02v.sys.comcast.net with ESMTP
	id 5W7PmaGLKGhhb5Xsbm8Ded; Mon, 19 Jul 2021 18:20:37 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net;
	s=20190202a; t=1626718837;
	bh=RJgD+oHMPsSV2Ov0WkBmXSIP/Vx0WZQhO8GnYFpdiZY=;
	h=Received:Received:Date:From:To:Message-ID:Subject:MIME-Version:
	 Content-Type;
	b=oXGIXA0DK+5sL++doDLPDxr4bi4cb8qh6qwvg6NUSepI19cuQA6pyi8Lml68iefXo
	 RlRdpMxwy0PkfG/tWq4kVNlNg+j7oTHyBPN2TtiGe1PfJA/7KWNNn4RsCLVtqaZ9mh
	 21FWPvAE74YGMWTYECq5Z7juTiKPTB3iRZjdmqspZ5OUFdQv/9hCjx8fXHaenZ/syw
	 njt7kGejuMH1iJLtm0jCe27ZvIGuRO0PmbErkZnJFLg69KMzmcNT4YmIrmFSm7U2UE
	 Zpp3cKpC0zQxN2gP0gZ4nD7QbxzDHHSZwJC6HhGn5cKnlZcu7oksQfG73duagGyAB9
	 rZOW4sF0q7xMg==
Received: from oxapp-ch2g-16o.email.comcast.net ([96.118.137.196])
	by resomta-ch2-17v.sys.comcast.net with ESMTPS
	id 5Xsbm7KAzDW595XsbmoJ9E; Mon, 19 Jul 2021 18:20:37 +0000
X-Xfinity-VAAS: 
 gggruggvucftvghtrhhoucdtuddrgedvtddrfedtgdduvdduucetufdoteggodetrfdotffvucfrrhhofhhilhgvmecuvehomhgtrghsthdqtfgvshhipdfqfgfvpdfpqffurfetoffkrfenuceurghilhhouhhtmecufedtudenucenucfjughrpeffhffvkffugggtrfgkofhisegrtdgssgertdejnecuhfhrohhmpeffteggkfffucftqffvjfcuoegruggrphhtrhhonhestghomhgtrghsthdrnhgvtheqnecuggftrfgrthhtvghrnhepjeevvefhvdfggeekieffveelleekudeuffejveeuveduuedvieehieefteejgeeinecukfhppeeliedruddukedrudefjedrudeliedpvdeitddumeduledumeekgedttdemugdvrgdtmeelugeiudemieefiegumegrvgelvdemhegtgeelnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehhvghlohepohigrghpphdqtghhvdhgqdduiehordgvmhgrihhlrdgtohhmtggrshhtrdhnvghtpdhinhgvthepleeirdduudekrddufeejrdduleeipdhmrghilhhfrhhomheprggurghpthhrohhnsegtohhmtggrshhtrdhnvghtpdhrtghpthhtohepphhgshhqlhdqnhhovhhitggvsehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh
X-Xfinity-VMeta: sc=0.00;st=legit
Date: Mon, 19 Jul 2021 14:20:36 -0400 (EDT)
From: DAVID ROTH <adaptron@comcast.net>
To: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Message-ID: <177614817.527205.1626718837077@connect.xfinity.com>
Subject: Nested Procedures
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_527204_585665558.1626718837071"
X-Priority: 3
Importance: Normal
X-Mailer: Open-Xchange Mailer v7.10.3-Rev18
X-Originating-IP: 2601:191:8400:d2a0:9d61:636d:ae92:5c49
X-Originating-Client: open-xchange-appsuite
List-Id: <pgsql-novice.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-novice@lists.postgresql.org>
List-Owner: <mailto:pgsql-novice-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-novice>
Archived-At: 
 <https://www.postgresql.org/message-id/177614817.527205.1626718837077%40connect.xfinity.com>
Precedence: bulk

------=_Part_527204_585665558.1626718837071
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Can I nest the definition of a procedure inside on another definition?
I am used to doing this in Oracle PL/SQL where a local procedure can be defined inside the declaration section of another procedure.

I am looking for 2 things as part of a migration effort.
1) Best way to replace Oracle packages.
2) Best way to define "private" procedures and functions.

Thanks
Dave R
------=_Part_527204_585665558.1626718837071
MIME-Version: 1.0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!doctype html>
<html>
 <head> 
  <meta charset="UTF-8"> 
 </head>
 <body>
  <div class="default-style" style="font-size: 12pt; font-family: helvetica,arial,sans-serif; color: #333333;">
   <span style="font-family: helvetica; font-size: 12pt;">Can I nest the definition of a procedure inside on another definition?</span>
  </div> 
  <div class="default-style" style="font-size: 12pt; font-family: helvetica,arial,sans-serif; color: #333333;">
   <span style="font-family: helvetica; font-size: 12pt;">I am used to doing this in Oracle PL/SQL where a local procedure can be defined inside the declaration section of another procedure.</span>
  </div> 
  <div class="default-style" style="font-size: 12pt; font-family: helvetica,arial,sans-serif; color: #333333;">
   &nbsp;
  </div> 
  <div class="default-style" style="font-size: 12pt; font-family: helvetica,arial,sans-serif; color: #333333;">
   <span style="font-family: helvetica; font-size: 12pt;">I am looking for 2 things as part of a migration effort.</span>
  </div> 
  <div class="default-style" style="font-size: 12pt; font-family: helvetica,arial,sans-serif; color: #333333;">
   <span style="font-family: helvetica; font-size: 12pt;">1) Best way to replace Oracle packages.</span>
  </div> 
  <div class="default-style" style="font-size: 12pt; font-family: helvetica,arial,sans-serif; color: #333333;">
   <span style="font-family: helvetica; font-size: 12pt;">2) Best way to define "private" procedures and functions.</span>
  </div> 
  <div class="default-style" style="font-size: 12pt; font-family: helvetica,arial,sans-serif; color: #333333;">
   &nbsp;
  </div> 
  <div class="default-style" style="font-size: 12pt; font-family: helvetica,arial,sans-serif; color: #333333;">
   <span style="font-family: helvetica; font-size: 12pt;">Thanks</span>
  </div> 
  <div class="default-style" style="font-size: 12pt; font-family: helvetica,arial,sans-serif; color: #333333;">
   <span style="font-family: helvetica; font-size: 12pt;">Dave R</span>
  </div> 
 </body>
</html>
------=_Part_527204_585665558.1626718837071--