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 1sJcRH-005toZ-5i for pgsql-general@arkaria.postgresql.org; Tue, 18 Jun 2024 17:16:11 +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 1sJcRE-00GygL-RZ for pgsql-general@arkaria.postgresql.org; Tue, 18 Jun 2024 17:16:09 +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 1sJcRE-00Gyf0-Gz for pgsql-general@lists.postgresql.org; Tue, 18 Jun 2024 17:16:09 +0000 Received: from mail-ot1-x32c.google.com ([2607:f8b0:4864:20::32c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sJcRC-001woF-Vy for pgsql-general@lists.postgresql.org; Tue, 18 Jun 2024 17:16:08 +0000 Received: by mail-ot1-x32c.google.com with SMTP id 46e09a7af769-6f855b2499cso3148467a34.1 for ; Tue, 18 Jun 2024 10:16:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1718730966; x=1719335766; 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=3Dm94A2NdOjRK8BsaLRE5hc0A/19HOT2UTtLet/LVdo=; b=Nn4I3/HwgAwcu8hL/YyyDraNshTd6RAR3K6Z0u2yu4HFkve5StZFaF2XoV9FRpYqrn xDtS/0u3BdutQAP8tEzswKz1MhDZAmiczqyVV/hYSO3IOUi3tfVNf/9Gu08PirwkC+Ck K+lX5SB63WkJFuDfj0tCyL1SRqOloSDg7CsppFNkcQFnCNsA6exDRNP1EjcLmtp80P1N XFRL19ArMuO0iWgHn4iB8BV5v65nJq7EpPnfXWraotnAy2vOTNFQ2hHYEtMWIU8gJ+sz TKqxGHWDw9HS5bX5Ta3v/u5MqP331T6pXrny/pNeN0ZH1ehnVOFL/p5bXv7HO6v30XoX xAXQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718730966; x=1719335766; 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=3Dm94A2NdOjRK8BsaLRE5hc0A/19HOT2UTtLet/LVdo=; b=AZs6dZ5PzN17fL8wrZKoywKTWgCDJxCe/BklCtJCcmaMqH6N6KxANxuAQVUAC12qf6 MKYvH+ps2G1jOr1LSkK+jx7dy1Q16vP5qbP6xCbK+CtWmHY96W0qOm5DebRlrzrShYVX bZkWmRVOMtY6LjOYBsvhuyo7ip1CzSGk/MsMvjIyLz6+YhH9xvBJaTO2pZpRucK5uiux lV9TQtAMfr1P1TJXBql1pFugbuXn4oN5VQ+HKYL8fGPcWe6z68jDLubfMe59TNoYyXaZ DjTU78k3+Od3Kl+qJbQKq4FHbtoiEtZCcGg6dMpB7kVR6iK3lQrdsHremrIqoUUdCieX XSQQ== X-Gm-Message-State: AOJu0Yy1FZDBfVDiq0NVzeA4MiRiOVDkK10W6P1lYX03qeITrckBUw9Q pzTgHuWPMX9hblyN0S5ohaBSC/4ZwFqLIeAvcbijDjaoxlsvbNWrzNOFel/8aigYnylzmITx6qH /IFOHt+wR5UGwZpUJsCCkCQpjovY= X-Google-Smtp-Source: AGHT+IH1Kka1F38erABdqkjSd3l+3SjkfBf7IoW+gqCMa/7rFMPaO/V9m3aiviSCtYQlYYkmi+IQK4/+mT6Dta/cvi0= X-Received: by 2002:a05:6870:64a2:b0:24f:d498:5e01 with SMTP id 586e51a60fabf-25c94d738e6mr468120fac.57.1718730966283; Tue, 18 Jun 2024 10:16:06 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: "David G. Johnston" Date: Tue, 18 Jun 2024 10:15:28 -0700 Message-ID: Subject: Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions To: Ron Johnson Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000b5ba37061b2d3c16" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b5ba37061b2d3c16 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Jun 18, 2024 at 10:07=E2=80=AFAM Ron Johnson wrote: > fun2 puzzles me. Why would you return parameters AND *a single record* (= unless > it's an error status). > You mis-understand what 2 is doing. You should go re-read the docs for create function again. Especially the description of rettype. David J. > --000000000000b5ba37061b2d3c16 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Jun 18, 2024 at 10:07=E2=80=AFAM Ron Johnson <<= a href=3D"mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com> w= rote:
fun2 puzzles=C2=A0me.= =C2=A0 Why would you return parameters AND a single record=C2=A0(unl= ess it's an error status).

<= div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif= ">You mis-understand what 2 is doing.=C2=A0 You should go re-read the docs = for create function again.=C2=A0 Especially the description of rettype.

David J.
--000000000000b5ba37061b2d3c16--