From: Garfield Lewis <garfield.lewis@lzlabs.com>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Get CTID from within an OUTPUT/SEND function
Thread-Topic: Get CTID from within an OUTPUT/SEND function
Thread-Index: AQHbjV+v5B8Iznsev0yb8WQQZkvhMw==
Date: Wed, 5 Mar 2025 00:09:03 +0000
Message-ID:
 <AM8PR05MB8257C674219A37B2116E111AE3C82@AM8PR05MB8257.eurprd05.prod.outlook.com>
Accept-Language: en-CA, en-US
Content-Language: en-CA
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?Windows-1252?Q?X04cPKlSQW9apHRU188ldHDrOWvdusch+Y5LkwgO5jXw6L+fCdOHNNQi?=
 =?Windows-1252?Q?h4qw/7uDwI4OaZTrc3UaSnZ7BSPnM0zosGBnmdrSojeyAwHtubGraV+M?=
 =?Windows-1252?Q?/8yck68bOc7zf1NXv2Q9nhzZg8CUfut3VWTmZn4rgtgNQmKnnvnW/xAr?=
 =?Windows-1252?Q?qcy1NcQQm1CylTdIOiSvV2SBIFNimEGVWGGPfSxAqY5uPLoGBtk3GE5p?=
 =?Windows-1252?Q?xgXnBu/dK2Ngb0n7sxIvzXyDsKOtlGUrG1atgcMXVWuwX55lpnP2DORw?=
 =?Windows-1252?Q?sgW9StDrDbpjLjWOF3BSBZ5KC7xjlR5yZZnZp6g4JyhetlvHqmvnJwDD?=
 =?Windows-1252?Q?JfniPCM7J3a2A08nPSNX5q8ZHT0qneuh4vXUSyFJVEuIb/8f1ULWtbZY?=
 =?Windows-1252?Q?2E1X1XfouvcoqPL5hTbkxgXQ67pX6MXzjwusZiRmGBdCivh9mj8U8JuA?=
 =?Windows-1252?Q?/VHsEfyQM21FXyMGWFQeXIIlxLv59hFDiZjLhoyggGCSkkbH64znwEme?=
 =?Windows-1252?Q?qjP7SfclwolHYZUT91Bf8IhyGQi2suqU5ZRtqqtNapJIGRykYY7iLERb?=
 =?Windows-1252?Q?nykQNZnt8OWrRkzyLYwFkFlYatvbVfjsvynOzzvkRiJxrA8WvtE5S3/9?=
 =?Windows-1252?Q?p2PMPuIJybb3dNR6bZRQLsJkc3MluET+4sGcbV4x4bZIoXSMgDe0yEkh?=
 =?Windows-1252?Q?QIdNZ/58NjUTyMVcCmHFnL/s8CnIOhCQYgfikxtYJ8tlfh+akCTFRT4l?=
 =?Windows-1252?Q?gGoYMh8uEj7zQYZ+2jSRfcMHsdvScAZrhNJILAU/pzkw5O4RVpU2san2?=
 =?Windows-1252?Q?OwHGDrZmxkor2iOLhZi6zdsiy5DMGkV+FmWkNnlDKbySTLd6EKdXsgZV?=
 =?Windows-1252?Q?woH11Rq8ZMbqhRmPta5Y18RaN35pDi4pcdBFrMwHKKGJVB9dHT1NdGhC?=
 =?Windows-1252?Q?Z1SVWQeu0Fzanyyqz82SUu7NX8PRPCHDh+qDM/x3lT1necbAvgw4+8Ev?=
 =?Windows-1252?Q?rS05nl0vnGBgll+v3dl/EPxkQdW9cL6iXUeU4QN9+whXh0rbG5gBfJ81?=
 =?Windows-1252?Q?9eNxnp9qjaCdGW9F+TmYbV0cDEY0vaO5uh4n4FWFEhnCcQo2XqHTLzPX?=
 =?Windows-1252?Q?Bf7VVHHBKE7bxtUpOTpUVR/np/SE+FW55a036jQ5rksOV10s79vf4dsc?=
 =?Windows-1252?Q?h9zTVaf2KyYzQFa4b5ibLeNyWBZZIboi6KH6GGHmU5Lm/aiwIsR8MAn9?=
 =?Windows-1252?Q?SKtYDxkM/Tm6nz0P9XEwj7P4gIlubAFdsgFS1plnahN6qzjYoPJbA6t6?=
 =?Windows-1252?Q?xHH6lYdnl4HjiBwDqk3/JXNv2oZFf6cUiBjw+79s9YlbUsj409IHwKGH?=
 =?Windows-1252?Q?cyeVHupArBTSQb2GPdOqvpyJlIz9erIKVnX2B03Fbax+hHgY12qfJGfc?=
 =?Windows-1252?Q?/A+BSADxwoOJFs7/bZB/FvrouV2ldJiB9aBU6/sgovqZw8ssWLP7elFD?=
 =?Windows-1252?Q?Xpdn7o1GRM+ThZ48o8CCv4CzJuXywwDzGt6TAmohc+luMMhh7Lfv2wLl?=
 =?Windows-1252?Q?s2rMF1UKv6UBFHE3s4i5X/La9JZM3bnnelaS0JmTcPR3s7/vm8u0pf8I?=
 =?Windows-1252?Q?4+DAOgmx3x4/ugHq26G5Ba2jWdja1K7xt0oJsR7htSpaEmV6S6s4vFU7?=
 =?Windows-1252?Q?AcFb0k0JbeNp4yYkUna+CXlF46FbqImo9EibdywCFpgoylMAj6fUxIpM?=
 =?Windows-1252?Q?JyNH5zlLzO7RqRhIW0s=3D?=
Content-Type: multipart/alternative;
	boundary="_000_AM8PR05MB8257C674219A37B2116E111AE3C82AM8PR05MB8257eurp_"
MIME-Version: 1.0
X-OriginatorOrg: lzlabs.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: AM8PR05MB8257.eurprd05.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: f41dc34e-88a8-49df-4a61-08dd5b79f080
X-MS-Exchange-CrossTenant-originalarrivaltime: 05 Mar 2025 00:09:04.0011
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: be5a2f53-aa84-427c-8fbd-c2d71558a7a8
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: kObY+AadzVqKJ7QprgiARmHF3FIpTsVdL1xyYMEqyVcr88jb7En3sfY/UHFAh2mq0hu1C3BdZpMbUlVWNAoa7cEM6HSUJtqbMOJl6NMNR68=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: AS8PR05MB7958
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/AM8PR05MB8257C674219A37B2116E111AE3C82%40AM8PR05MB8257.eurprd05.prod.outlook.com>
Precedence: bulk

--_000_AM8PR05MB8257C674219A37B2116E111AE3C82AM8PR05MB8257eurp_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I would like to know if it is possible to get the CTID from within the OUTP=
UT and SEND functions of a CREATE TYPE? I=92ve found a function called curr=
tid_byrelname and the comment in the function prolog says it is to get a CT=
ID but I cannot find any example usage of it.

Regards,
Garfield

--_000_AM8PR05MB8257C674219A37B2116E111AE3C82AM8PR05MB8257eurp_
Content-Type: text/html; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:sc=
hemas-microsoft-com:office:word" xmlns:m=3D"http://schemas.microsoft.com/of=
fice/2004/12/omml" xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1=
252">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Aptos;
	panose-1:2 11 0 4 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:12.0pt;
	font-family:"Aptos",sans-serif;
	mso-ligatures:standardcontextual;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Aptos",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style>
</head>
<body lang=3D"EN-CA" link=3D"#467886" vlink=3D"#96607D" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt">I wo=
uld like to know if it is possible to get the CTID from within the OUTPUT a=
nd SEND functions of a CREATE TYPE? I=92ve found a function called
<b>currtid_byrelname</b> and the comment in the function prolog says it is =
to get a CTID but I cannot find any example usage of it.<o:p></o:p></span><=
/p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt"><o:p=
>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt">Rega=
rds,<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt">Garf=
ield<o:p></o:p></span></p>
</div>
</body>
</html>

--_000_AM8PR05MB8257C674219A37B2116E111AE3C82AM8PR05MB8257eurp_--