Thread: Get CTID from within an OUTPUT/SEND function
I would like to know if it is possible to get the CTID from within the OUTPUT and SEND functions of a CREATE TYPE? I’ve found a function called currtid_byrelname and the comment in the function prolog says it is to get a CTID but I cannot find any example usage of it.
Regards,
Garfield
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
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