Re: user defined types and strings

Kjetil Haaland <kjetil(dot)haaland(at)student(dot)uib(dot)no> writes:
> On Wednesday 23 February 2005 18:23, Michael Fuhr wrote:
>> Hmmm...haven't we already had this conversation? :-)

> We have had almost the same conversation before. The type works in my
> functions, but since the string is just a pointer to a memory place it goes
> away when the type is stored in tables in the database.

The point here is that you've built a two-part structure:

<length> <pointer to string> <some other fields>
|
+------------> text of string

and this is fundamentally not going to work. A datum has to be one
piece of memory. Consider something like

<length> <some other fields> <text of string>

where the length is now variable.

regards, tom lane