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 ) id 1m5gfd-0004UQ-7Y for pgsql-novice@arkaria.postgresql.org; Tue, 20 Jul 2021 03:43:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m5gfa-0001Bq-6P for pgsql-novice@arkaria.postgresql.org; Tue, 20 Jul 2021 03:43: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 ) id 1m5gfZ-0001Bi-Tz for pgsql-novice@lists.postgresql.org; Tue, 20 Jul 2021 03:43:45 +0000 Received: from mail-vs1-xe36.google.com ([2607:f8b0:4864:20::e36]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m5gfV-00009f-Ag for pgsql-novice@lists.postgresql.org; Tue, 20 Jul 2021 03:43:44 +0000 Received: by mail-vs1-xe36.google.com with SMTP id h5so10541264vsg.12 for ; Mon, 19 Jul 2021 20:43:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=yp7uB5EDX+0qHw88jfDdJ9PPEfoNbvfnR+WPu/dAi6Y=; b=mUgA0cwJ99A9J/IKIsXzcI+k0is+waPzr1XkUHtAbMaY556cUCzpa+V53kUPPagwdF Z8NTJF2FjsAxFJs1dZJCAtH9Kslx3xw32ZYUtmVslycj8X0AKlJhG2iT/IKbB/u8B2jV he6iDZEjLqIHiytY20JHVob0ba47kXiLqREdSf/uKttjn9Yw4u3ackils2UIdSP9V/jg 9b8UXh8suIBWaQMiTbnsSNU/TIGD9aAVLUSleL/kUDL0x1zPcTEZvzdWxcJlCUKPX7sV ThpwV1TR9RFuqGzk350O9lrulGv11T20GfvwmjWiXmY2NhEDECHH8C0btdMBxfZ51eYD 5qvg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=yp7uB5EDX+0qHw88jfDdJ9PPEfoNbvfnR+WPu/dAi6Y=; b=b51mbhqZMv3vKXTv6Jf2VDRjrwugkSmaGVrA9KNP9amZOE/sMrAkrXZcOXfxZacahK NXT63k+OMuTSuY3g6KUC2r/DZreq1/u4djION0rRRPWJ736pKn89mByR6TTVIwUiC1dt /pshIkWvR649lpCqzvW39ULOy9Ib0icSclLUt/0Mx4GMoXln0tThtVTXxLEIPeb/opZV SaCbsKzCzY+2QPRmNt3ldXnWVuKfQ2Pht3BejJhtmV2HMUm/QkLqhWoF1nPhGQXnjy/V QJthk1rGyHhiiXQ7vGokjC/aT95/rl9KLU4F0g6E9LYsqlWEDoFP7bB49wy8mP0lNHhR ZiqQ== X-Gm-Message-State: AOAM533VXwgi+GII5BxNK/om1Wk2qKxLKHzAekUiAeifzFfvoUGVYcmd JW2dlutAQc0nBXWNlW/MZLmdtOKZ29DprfNLAEA= X-Google-Smtp-Source: ABdhPJygF4l8hbYu/qrkzyLgx8IvHs6tTiCcFcGWwEBw0+GR5VwLNRcqInN9AhrPxpin71uq8NBlzoS2Sc69YOB2D8I= X-Received: by 2002:a05:6102:f07:: with SMTP id v7mr26022467vss.27.1626752619819; Mon, 19 Jul 2021 20:43:39 -0700 (PDT) MIME-Version: 1.0 References: <177614817.527205.1626718837077@connect.xfinity.com> In-Reply-To: <177614817.527205.1626718837077@connect.xfinity.com> From: Amul Sul Date: Tue, 20 Jul 2021 09:13:03 +0530 Message-ID: Subject: Re: Nested Procedures To: DAVID ROTH Cc: "pgsql-novice@lists.postgresql.org" Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PostgreSQL doesn't have those options, but EDB Postgres Advanced Server does provide that. Regards, Amul On Mon, Jul 19, 2021 at 11:50 PM DAVID ROTH wrote: > > 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