Kjetil Haaland <kjetil.haaland@student.uib.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