MIME-Version: 1.0
References: 
 <LV3PR16MB6001AF4D05893E9FF4B3C746E6CE2@LV3PR16MB6001.namprd16.prod.outlook.com>
 <3528232.1718682678@sss.pgh.pa.us>
 <LV3PR16MB6001CD31C5982777BA9BA25EE6CE2@LV3PR16MB6001.namprd16.prod.outlook.com>
 <LV3PR16MB6001216CE02B2D908F9D87ECE6C82@LV3PR16MB6001.namprd16.prod.outlook.com>
 <LV3PR16MB60014D610A726368182ACC7EE6C92@LV3PR16MB6001.namprd16.prod.outlook.com>
In-Reply-To: 
 <LV3PR16MB60014D610A726368182ACC7EE6C92@LV3PR16MB6001.namprd16.prod.outlook.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 21 Jun 2024 07:48:16 -0700
Message-ID: 
 <CAKFQuwY76Jc=6JJOPzAt98RLuGCgCdNnS6syB0T4hF6iA=+uoQ@mail.gmail.com>
Subject: Re: RowDescription for a function does not include table OID
To: Maxwell Dreytser <Maxwell.Dreytser@assistek.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c59ded061b678786"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwY76Jc%3D6JJOPzAt98RLuGCgCdNnS6syB0T4hF6iA%3D%2BuoQ%40mail.gmail.com>
Precedence: bulk

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

On Fri, Jun 21, 2024 at 7:42=E2=80=AFAM Maxwell Dreytser <
Maxwell.Dreytser@assistek.com> wrote:

> I am working on a meta-programming use-case where I need to scrape some
> detailed information about the results of a function that "RETURNS TABLE
> (LIKE physical_table)"
>

Yes, but the bug is yours.  The definition you want is:  RETURNS SETOF
physical_table (not tested though)

What you did was produce a one-column table whose column type is a
composite (and whose name is like - what with case-folding of unquoted
identifiers).  Since that table doesn't exist anywhere in the catalogs it
has no TableOID.

David J.

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

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Fri, Jun 21, 2024 at 7:42=E2=80=AFAM Maxwell Dreytser &=
lt;<a href=3D"mailto:Maxwell.Dreytser@assistek.com">Maxwell.Dreytser@assist=
ek.com</a>&gt; wrote:</span><br></div></div><div class=3D"gmail_quote"><blo=
ckquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left=
:1px solid rgb(204,204,204);padding-left:1ex"><div class=3D"msg292325358975=
0766221">


<div dir=3D"ltr">
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:11pt;color:rgb(0,0,0)"><span style=3D"fo=
nt-size:11pt">I am working on a meta-programming use-case where I need to s=
crape some detailed information about the results of a function that &quot;=
RETURNS TABLE (LIKE physical_table)&quot;</span><br></div></div></div></blo=
ckquote><div><br></div><div class=3D"gmail_default" style=3D"font-family:ar=
ial,helvetica,sans-serif">Yes, but the bug is yours.=C2=A0 The definition y=
ou want is:=C2=A0 RETURNS SETOF physical_table (not tested though)</div><di=
v class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">=
<br></div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica=
,sans-serif">What you did was produce a one-column table whose column type =
is a composite (and whose name is like - what with case-folding of unquoted=
 identifiers).=C2=A0 Since that table doesn&#39;t exist anywhere in the cat=
alogs it has no TableOID.</div><div class=3D"gmail_default" style=3D"font-f=
amily:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default" st=
yle=3D"font-family:arial,helvetica,sans-serif">David J.</div><div class=3D"=
gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br></div><=
/div></div>

--000000000000c59ded061b678786--