From: | Ken Kachnowich <khkachn(at)telocity(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: User defined type with text* field |
Date: | 2001-07-01 16:04:29 |
Message-ID: | 3B3F4A0D.4FC128AA@telocity.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
What I want to do is create a Serialize type for storing Java objects.
The text would be the class name and the Oid would point to the record
where the object is stored. I need the class name and not the Oid of the
table because of a problem I have with long class names (> 32
characters).
If I figure out how to make this a "varlena" value would variable then
work
for the length specification in the create type command?
Are there any examples of varlena user types I could look at?
Thanks,
Ken
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Pilosov | 2001-07-01 20:31:10 | Re: Re: User defined type with text* field |
Previous Message | Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= | 2001-07-01 14:19:03 | Re: A small question about Red Hat |