From: Garfield Lewis <garfield.lewis@lzlabs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: [EXT] Re: Get CTID from within an OUTPUT/SEND function
Thread-Topic: [EXT] Re: Get CTID from within an OUTPUT/SEND function
Thread-Index: AQHbjV+v5B8Iznsev0yb8WQQZkvhM7NjsZEAgAAKNcI=
Date: Wed, 5 Mar 2025 01:12:13 +0000
Message-ID:
 <AM8PR05MB8257FD0C08D242968EB37BE3E3CB2@AM8PR05MB8257.eurprd05.prod.outlook.com>
References:
 <AM8PR05MB8257C674219A37B2116E111AE3C82@AM8PR05MB8257.eurprd05.prod.outlook.com>
 <213107.1741134784@sss.pgh.pa.us>
In-Reply-To: <213107.1741134784@sss.pgh.pa.us>
Accept-Language: en-CA, en-US
Content-Language: en-CA
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?us-ascii?Q?0iGh0zR76HxqwfcCBtSjcrDcGrj9/aSKqRYpb/n9run1ZPt/fKEgS9Z2xPyK?=
 =?us-ascii?Q?AI3CFQWHBALtu9evEGRfwBG3Gvx/WBzMKPZFeQJP+FL+wAzvspN4BRD0nyPl?=
 =?us-ascii?Q?rA2GjI/gepa+eWDnvcEQAwTukQvPqVgvmf8CA4GtT+EE3Wa2AFRPn59jnbHv?=
 =?us-ascii?Q?luoKVSsK8ET4gzTr3Qa9iYPKJgI2Z9tPqZHaLFi1MS5U/Mq213+E3TYnibC4?=
 =?us-ascii?Q?rse1I3DZeRoRGOWq2C7YQEJygGyfuZFWrDD7D+gJm2sRu9W1Zd3lv2xDsh2C?=
 =?us-ascii?Q?DbHv46VGD4+Ubk7GbBRJrP5WZHQ7Q52R3xKrYUK2yLOaSs/YaAovLbcWiHKg?=
 =?us-ascii?Q?XXBAuBdvXgeygdqNlYh55n5RtLA5M7kSgHSmiX2EeP7fNDpawY/ecxpcUV+J?=
 =?us-ascii?Q?X8bS3b6vjIdhGS/5vdqkID59FbiUNbSMEvhhWAUhR7MSa4T2JB4PEBY3RyG/?=
 =?us-ascii?Q?hSK3wndw4vGIRZMSAIKk8JrTD4Qfjrjb+ZPCEiPbu201RtqegDn6do70CLIi?=
 =?us-ascii?Q?rfBIkLyXMrfb2uAZPYJSsgTuwpFpQxnXBV7Mt37GzKNq/NXbG90CzNIWFKTF?=
 =?us-ascii?Q?o2b/hMDuFkaL+mzJcVbu/6sB4NPqbNtMI4idUIu4/Q/CcwRWKgk4pjX+UDa8?=
 =?us-ascii?Q?+tcPJPZASaSWw3pyEqrTZHUarVr3CMc6VDoB2ilKb2oNmL643uYTV8lT/YfA?=
 =?us-ascii?Q?nCb1QJ+6CXWxGtcsoZibcJdpPExbvy1IB06nVfVEOSVkBY5MpZp17T+u7qRO?=
 =?us-ascii?Q?L1ReBZZcafiP08ZbtketYtoPUaGxN4IeRc2XOEIv4gDmPef+l25NiQ5OSt9z?=
 =?us-ascii?Q?9Y3ih7g3j97ZXt2pqSpLywitjATid2XvnY2ojnciRLM6fI6ZbsbTB1rrTj0X?=
 =?us-ascii?Q?6YIzs+pzfhKAp81lulSNJ17M16qpgsLA4G6imFSb08xQRUEh6TgBWGevDZgU?=
 =?us-ascii?Q?IY7ZlvMx8l0qxmX0cXeyqJQPCQOn8ZYfptH10Ts6QicOF5LLQOnePcaDRL7d?=
 =?us-ascii?Q?9nrIhqguQKatGHCd1i+D4/wriDNwC6QHf4huSvG+YejyIIAt7gNDMG5hzvrX?=
 =?us-ascii?Q?jP/8V/9ttS18lIL+bnAixMGcMbqmY6jVu0qxwj/gjPxJn4psNNDTIfuR9Qkj?=
 =?us-ascii?Q?5bI7/LR/m835idwbweXmi2ttghq05Cr8EpIQCWHdzj+lyl/KiOLMowwzg9Tm?=
 =?us-ascii?Q?xIYoyciuNa6JY1o3yw3Kn7CeoOKlRfMvMapPhbq8Fw1kNSFmKq3+qwKxlUti?=
 =?us-ascii?Q?AxsdkZ/6tXLMccHn8aK1uUWeG08QM/1dNp+cy6xfdoKHgMY9v3047t4aYtQ+?=
 =?us-ascii?Q?hvuNW3iOnTubJiKKUoQ3lyYNYE0fslw5b4rElkTaTL+4zg2j1dyP/wu7oL45?=
 =?us-ascii?Q?dJbf/IZdBQcHirReoDEU2kLCu8HInr0uBUdx5dptoOdVci9wcOiKeGmtrF/e?=
 =?us-ascii?Q?4QwiEuSpF1LXay7y7bPCEh8+pKBBeSXDR6Zjoz2sTtSmuk4S+6B7PwXJFhsN?=
 =?us-ascii?Q?72LjOECyOXpfnjqinrXtoFlGjEOgivbJrK+ljpVoh6NQ82tQPExhCA/uDsYa?=
 =?us-ascii?Q?fXk9JljZYwmZw7S2R4WfuksjbEzOA/lpDWBp1TkUUOubw5hu1BdJxzZs3S6U?=
 =?us-ascii?Q?cFl+bVa5DyvH0BYSWEgNAME=3D?=
Content-Type: multipart/alternative;
	boundary="_000_AM8PR05MB8257FD0C08D242968EB37BE3E3CB2AM8PR05MB8257eurp_"
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: 6e9fe0be-be7b-442e-9abb-08dd5b82c2eb
X-MS-Exchange-CrossTenant-originalarrivaltime: 05 Mar 2025 01:12:13.0294
 (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: CeiiOWPR58de/spLaxDw2RsiD9Li0JQQvSNgbWLkq5eMU5Fuu0XSRJOn5nYqxK0OJCdMm+MEB4+E1vKp9dbXYmS/sAcNSQ+odOI3r/lgYjU=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: AS5PR05MB10996
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/AM8PR05MB8257FD0C08D242968EB37BE3E3CB2%40AM8PR05MB8257.eurprd05.prod.outlook.com>
Precedence: bulk

--_000_AM8PR05MB8257FD0C08D242968EB37BE3E3CB2AM8PR05MB8257eurp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Garfield Lewis <garfield.lewis@lzlabs.com> writes:
> > I would like to know if it is possible to get the CTID from within
> > the OUTPUT and SEND functions of a CREATE TYPE?
>
> No.  A datatype output function has no reason to expect that the value
> it's handed has ever been in a table at all.
>
>                      regards, tom lane

Thx, Tom

--_000_AM8PR05MB8257FD0C08D242968EB37BE3E3CB2AM8PR05MB8257eurp_
Content-Type: text/html; charset="us-ascii"
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=3Dus-ascii"=
>
<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:10.0pt;
	font-family:"Aptos",sans-serif;}
span.EmailStyle19
	{mso-style-type:personal-reply;
	font-family:"Aptos",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;
	mso-ligatures:none;}
@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">
<div id=3D"mail-editor-reference-message-container">
<div>
<div>
<div>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt">Garfield Lewis &lt;=
garfield.lewis@lzlabs.com&gt; writes:<br>
&gt; &gt; I would like to know if it is possible to get the CTID from withi=
n<br>
&gt; &gt; the OUTPUT and SEND functions of a CREATE TYPE?<br>
&gt;<br>
&gt; No.&nbsp; A datatype output function has no reason to expect that the =
value<br>
&gt; it's handed has ever been in a table at all.<br>
&gt;<br>
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; regards, tom lane<o=
:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt">Thx, Tom<o:p></o:p>=
</span></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>

--_000_AM8PR05MB8257FD0C08D242968EB37BE3E3CB2AM8PR05MB8257eurp_--