Re: User defined type with text* field

Ken K <kenmail(at)telocity(dot)com> writes:
> I am trying to create a user defined type with 2 fields
> in it, a text* and an Oid. I am not sure what size to
> use in the create type command. When I try variable
> the back end core dumps. Are there any examples for
> doing this sort of thing? Is it even doable?

You can't use any kind of pointer in a datatype --- what is it going to
point to? There's nothing it could point at that might live as long as
the datavalue on disk will.

You could embed a TEXT value into a larger varlena value, say

<total length word>
Oid
<text value here, beginning with its own length word>

regards, tom lane