MIME-Version: 1.0
References: <CACX+KaPBaSW+0PyMC7dmY6W9W8mPSbWpkJRhAOQOC9Qb0TjCQA@mail.gmail.com>
 <CAKFQuwbtbhkbw439S3_UbraTpyHfQGxdjjhBBUbfKPd4PVC+xg@mail.gmail.com>
In-Reply-To: <CAKFQuwbtbhkbw439S3_UbraTpyHfQGxdjjhBBUbfKPd4PVC+xg@mail.gmail.com>
From: Ayush Vatsa <ayushvatsa1810@gmail.com>
Date: Wed, 19 Jun 2024 22:16:44 +0530
Message-ID: <CACX+KaMore7Q-5QUQnTT5R0gKmsa_4jzqn+cmMaSwv6f2KWXCQ@mail.gmail.com>
Subject: Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000003cfcaf061b40f2b7"
Archived-At: <https://www.postgresql.org/message-id/CACX%2BKaMore7Q-5QUQnTT5R0gKmsa_4jzqn%2BcmMaSwv6f2KWXCQ%40mail.gmail.com>
Precedence: bulk

--0000000000003cfcaf061b40f2b7
Content-Type: text/plain; charset="UTF-8"

Hi David,
Thanks for clarification
> I prefer TABLE.  Using setof is more useful when the returned type is
predefined
But in the table also isn't the returned type predefined? Example:
CREATE FUNCTION fun1(integer)
RETURNS TABLE(
        col1 integer,
        col2 text
)
AS 'MODULE_PATHNAME', 'fun1'
LANGUAGE C;
We know the returned type will have two columns with type -  integer and
text. Am I correct?

> Or a true record where the caller has to specify the shape.
Sorry but didn't get this shape part?

Thanks
Ayush Vatsa

--0000000000003cfcaf061b40f2b7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Hi David,<br>Thanks for clarification<br>=
&gt;=C2=A0<span style=3D"font-family:arial,helvetica,sans-serif">I prefer T=
ABLE.=C2=A0 Using setof is more useful when the returned type=C2=A0is prede=
fined<br>But in the table also isn&#39;t the returned type predefined? Exam=
ple:</span></div><div dir=3D"ltr">CREATE FUNCTION fun1(integer)<br>RETURNS =
TABLE(<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 col1 integer,<br>=C2=A0 =C2=A0 =C2=A0=
 =C2=A0 col2 text<br>)<br>AS &#39;MODULE_PATHNAME&#39;, &#39;fun1&#39;<br>L=
ANGUAGE C;<br></div><div>We know the returned type will have two columns wi=
th type -=C2=A0 integer and text. Am=C2=A0I correct?</div><div><br></div><d=
iv>&gt;=C2=A0<span style=3D"font-family:arial,helvetica,sans-serif">Or a tr=
ue record where the caller has to specify the shape.<br>Sorry but didn&#39;=
t get this shape part?<br><br>Thanks<br>Ayush Vatsa</span></div></div>

--0000000000003cfcaf061b40f2b7--