Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qsmN3-009LN1-FJ for pgsql-sql@arkaria.postgresql.org; Tue, 17 Oct 2023 15:52:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qsmN1-00BX4A-AE for pgsql-sql@arkaria.postgresql.org; Tue, 17 Oct 2023 15:52:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qsmN1-00BX3u-17 for pgsql-sql@lists.postgresql.org; Tue, 17 Oct 2023 15:52:35 +0000 Received: from mail-ed1-x530.google.com ([2a00:1450:4864:20::530]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qsmMv-000wNQ-1k for pgsql-sql@lists.postgresql.org; Tue, 17 Oct 2023 15:52:34 +0000 Received: by mail-ed1-x530.google.com with SMTP id 4fb4d7f45d1cf-53e2dc8fa02so8555967a12.2 for ; Tue, 17 Oct 2023 08:52:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1697557947; x=1698162747; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=8tKH9BFLo1yKfUvjd/kxCBcaqZ4GbPwxfsnIHbwOb8k=; b=UN1MwsFOAHEsp70abRVpH9KMMeksG1mORZx9z3TCXPwwmzGFvHDAY2zL5U8hFv1WT6 K4LRLIqsJj2X3Y74dlEdokmJZNCWhZuJa1Y8G4jfvxlGL91bJcPUYUtzIqth8Ihw+CU5 yNxJRfJJWDxTNqmaMTRIIwhVUEhx5mfU5NJwH8701D164zFmXVVrpHdMTaMUii7iwmaE mNFLfIBd5iuL4w8tzSPF75sZgFDP0SjstzS+/UXMHjU3upS+0kYMftv6ah+OwSW3zxwV 506bMdFU/nVc1zapc4ZS3lu+LED6VOPsM1V90gLbhQFlxM50Kjz0SzLuCk0FMzTY4Ky7 5JxA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1697557947; x=1698162747; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=8tKH9BFLo1yKfUvjd/kxCBcaqZ4GbPwxfsnIHbwOb8k=; b=jV0fir9gZmlhiv9LoeH6xl0a8zUFQao52YKNbgZ3G3p49fAUDE7gopd11JEQT1YeRi Ok8FnIgy0IisUJG5iUEs7AtA+z9DE/ILI05ke3/ys8qZ2xP4W0i2kryAqX4wzm7doz1d g8a0T8V0DtAnVSDqIv1LordsIodmuNZaA1MZIUTZ1hakMUr1Wlw2AZJJi8WmpsCKPj4u sCsRFZaDFmtwYkB+Squguvh5LN+/L9p3Kgqc/4gefIn2Tz1td0NOh1Uxp5gW4Ez85foi tniR51uQx5E+7StOSRjTL7XNtX5og1YuJKoTcck3U81Awj+/w6IeF6MbOF8TpWo0QfPL xAWw== X-Gm-Message-State: AOJu0YwdRHuiJaWyawtVX6QUuIiA/4y3f0pNzRemFc91ewugWSD4dCd+ eSMsBBb8TZGgsdsoj0FAHZCqbV1GMONTIY75vybmvcPu X-Google-Smtp-Source: AGHT+IFkva7MTtq0+bD41siFnHkYV2ZysK/6BAxc+MwPKTZ0LyOJP970pNicCQ5CAhion6g7G2IkFN8GbhEpL6Six6E= X-Received: by 2002:a05:6402:2550:b0:532:e71b:5ead with SMTP id l16-20020a056402255000b00532e71b5eadmr1976827edb.32.1697557947271; Tue, 17 Oct 2023 08:52:27 -0700 (PDT) MIME-Version: 1.0 From: Shaozhong SHI Date: Tue, 17 Oct 2023 16:52:16 +0100 Message-ID: Subject: stored procedures To: pgsql-sql Content-Type: multipart/alternative; boundary="0000000000006ed02e0607eb8247" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006ed02e0607eb8247 Content-Type: text/plain; charset="UTF-8" How easily turn do statement scripts into stored procedures? Much modification is needed? What is the advantage to do so? Regards, David --0000000000006ed02e0607eb8247 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
How easily turn do statement scripts into stored procedure= s?=C2=A0 Much modification is needed?

What is the advant= age to do so?

Regards,

Da= vid
--0000000000006ed02e0607eb8247--