Re: User defined type with text* field

Ken K <kenmail@telocity.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