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 1uvbhH-00G4XN-Io for pgsql-general@arkaria.postgresql.org; Mon, 08 Sep 2025 13:14:16 +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 1uvbhF-004aj7-QK for pgsql-general@arkaria.postgresql.org; Mon, 08 Sep 2025 13:14:14 +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 1uvbhF-004aiy-Fs for pgsql-general@lists.postgresql.org; Mon, 08 Sep 2025 13:14:13 +0000 Received: from mail-il1-x131.google.com ([2607:f8b0:4864:20::131]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uvbhE-0019z6-0h for pgsql-general@lists.postgresql.org; Mon, 08 Sep 2025 13:14:13 +0000 Received: by mail-il1-x131.google.com with SMTP id e9e14a558f8ab-407240934c9so10286645ab.2 for ; Mon, 08 Sep 2025 06:14:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1757337250; x=1757942050; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=wWR83GaDzZfOAkG5021Y7b21wW21sUdjTQtyY1JmAis=; b=JdeXhnS/ewyqdFbAWtQEMfUJIp5Vyz7shcAdMpQfx90jWBrI7hfIKKTEQ+5IZXLihz 62HWiYj9lAiqlL6tKJGQxbTFNMcCoN0iWLfQjhOSgsVU7ICmYT/PVGd1lhnV8yBP/0NZ RstzJKEyzEbhYMDyKKwGH9MIS226/ToViTBWaBKug/+Zd1mma79HkY3f5d4F8Z0R8L6x Wiz/iz/FrYV8HBCf+ONJZ285Rku9SyDEKLoOQCnJVQn53ITL7xWvfmjSk3ajS87ow8G6 zuDJKEQxtih96BySDhV1H5N+CS5LtbMbmShNpSGmVfaXyDKoZmbRDZCmRXaHt5c8gb7L sGVQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757337250; x=1757942050; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=wWR83GaDzZfOAkG5021Y7b21wW21sUdjTQtyY1JmAis=; b=cK3COzjaSzk5meijTtQqwqu431Oo0IU9YqjP4g3O/OtjbED+H8VL2vucAsdrpxDc5E LIrZKETfHU9q5+uzqTy4kMyLc0L3idAxBNJRUbbKqnPp0JunzwZrRVkbDbN0IhwQuAye rDJFqHRZCRDsnc/YnlvkDs2m7BUAytY7RyEdXi2i7LS4H6vXsGnCc5l8eNAR9DaHPa1T 4fSavTWibdKOwxa3CdJ61zgyHmavz8p7fQUEO4yEcI8gN6qcHMNy5sMG/fdueM5zeFoc 2szzVGuO1ORRVcHNqVOz/nkND06RV+CYrsZVLpRFx58E5zl60Ei0Lt3GaNdqpN+kC7S6 n4Ng== X-Forwarded-Encrypted: i=1; AJvYcCX6G3E63O372dSSmvQc5k7uZNSFFL0qfkmuFPLS/kCOWLcKQG75WBCWbgx3onT4NbdhMvlpwygmsCAEqGkk@lists.postgresql.org X-Gm-Message-State: AOJu0YyZeaR3w/OjHpte4BNp3a9suZoJjUcWu4ZQfkU/twk6fxrZNV9n MCeryx/y1Rp0E0jUHKlmbgjQrPQxJ4N02i1vkjkJaQ9aDZwn1GPMcMTo2+gmgTH7uZ8WM1Jhaos tRn8YamMY3Ej3W5ro1FaatlXb7pq3wX8= X-Gm-Gg: ASbGnct+Ivs0HFvTNrXEWa2t01qo0eh0Qhw6IoQN7FgvwY/DzBUO6m4Sa/FPMT32q5q d/H9o+QN3lsgdmSnGunod3v9f8LVPJBOxv5axn5JshhHvTH7til2NYCzNpG3ePCRp7GKG6iFjb5 OTYyCbBEWhYtQ2hU84WmP7rU60jlJoEPJYdPA9QQXkl9fdzppErLjl8y5wtyAw6Uto185sjnwtR fh/9DjxjQRISzQbJDC4VZ+xpye+WkMLUzuNpYo56w== X-Google-Smtp-Source: AGHT+IH87+kizOolCj6XcDj6u8ZSy604HLY7zzP19nhL0NjPTXPrrRmxnlaSGgCUs96M1ZWCAwQF2+erI6GC6mHnBaI= X-Received: by 2002:a05:6e02:1a27:b0:406:7c54:9f6c with SMTP id e9e14a558f8ab-4067c549fe1mr53469795ab.7.1757337250495; Mon, 08 Sep 2025 06:14:10 -0700 (PDT) MIME-Version: 1.0 References: <1985501673.206991527.1757078030654.JavaMail.zimbra@meteo.fr> <890069544.207914575.1757324233380.JavaMail.zimbra@meteo.fr> In-Reply-To: <890069544.207914575.1757324233380.JavaMail.zimbra@meteo.fr> From: Greg Sabino Mullane Date: Mon, 8 Sep 2025 09:13:33 -0400 X-Gm-Features: Ac12FXxJSWFeEMn5UKjjf46Fnw_lGdUevwASqEdpXbV8ecAIz-33GFWrKwwFupQ Message-ID: Subject: Re: PostgreSQL include directive in plpgsql language PL/pgSQL To: PALAYRET Jacques Cc: Merlin Moncure , pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000009101f3063e49f6a6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009101f3063e49f6a6 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Sep 8, 2025 at 5:37=E2=80=AFAM PALAYRET Jacques wrote: > I can manage with this method, but it shoud be better with a include > directive. > Even if we had includes, I would strongly advise "this method" which seems pretty clean and maintainable. What is the issue with SQL functions that call a parent function and slightly manipulate the results? Cheers, Greg -- Crunchy Data - https://www.crunchydata.com Enterprise Postgres Software Products & Tech Support --0000000000009101f3063e49f6a6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Sep 8, 2025 at 5:37=E2=80=AFAM PA= LAYRET Jacques <jacques.pal= ayret@meteo.fr> wrote:
I can manage with= this method, but it shoud be better with a include directive.
=

Even if we had includes,= I would strongly advise "this method" which seems pretty clean a= nd maintainable. What is the issue with SQL functions that call a parent fu= nction and slightly manipulate the results?
=C2=A0
--0000000000009101f3063e49f6a6--