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

--000000000000da7528061b40ff74
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wednesday, June 19, 2024, Ayush Vatsa <ayushvatsa1810@gmail.com> wrote:

> 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?
>

Sorry, predefined independently of the function.  Using create type then
referring to that type by name in the create function.


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

=E2=80=A6 from rec_func as (col1 isn=E2=80=99t, col2 text) =E2=80=A6

The shape is two columns, type int and text respectively.

David J.

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

On Wednesday, June 19, 2024, Ayush Vatsa &lt;<a href=3D"mailto:ayushvatsa18=
10@gmail.com">ayushvatsa1810@gmail.com</a>&gt; wrote:<br><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">Hi David,<br>Thanks for cla=
rification<br>&gt;=C2=A0<span style=3D"font-family:arial,helvetica,sans-ser=
if">I prefer TABLE.=C2=A0 Using setof is more useful when the returned type=
=C2=A0is predefined<br>But in the table also isn&#39;t the returned type pr=
edefined? Example:</span></div><div dir=3D"ltr">CREATE FUNCTION fun1(intege=
r)<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>LANGUAGE C;<br></div><div>We know the returned type will have =
two columns with type -=C2=A0 integer and text. Am=C2=A0I correct?</div></d=
iv></blockquote><div><br></div><div>Sorry, predefined independently of the =
function.=C2=A0 Using create type then referring to that type by name in th=
e create function.</div><div>=C2=A0</div><blockquote class=3D"gmail_quote" =
style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><di=
v dir=3D"ltr"><div><br></div><div>&gt;=C2=A0<span style=3D"font-family:aria=
l,helvetica,sans-serif">Or a true record where the caller has to specify th=
e shape.<br>Sorry but didn&#39;t get this shape part?</span></div><div></di=
v></div></blockquote><div><br></div><div>=E2=80=A6 from rec_func as (col1 i=
sn=E2=80=99t, col2 text) =E2=80=A6</div><div><br></div><div>The shape is tw=
o columns, type int and text respectively.</div><div><br></div><div>David J=
.</div><div><br></div>

--000000000000da7528061b40ff74--