user defined types and strings

From: Kjetil Haaland <kjetil(dot)haaland(at)student(dot)uib(dot)no>
To: pgsql-novice(at)postgresql(dot)org
Subject: user defined types and strings
Date: 2005-02-23 13:01:36
Message-ID: 200502231401.36646.kjetil.haaland@student.uib.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi

I have made a user defined type which has a string of variable length and and
an integer value. Since the string is of variable length i have used a
pointer for the string. When i use this type as a column in a table and
inserts values into it, the string will go away. I understand that this is
because i am pointing to a place in memory for the string, and that this wont
last for a very long time. So i am wondering how i am supposed to use strings
in a user defined type so they will be saved in the database when the type is
inserted in a table?

-Kjetil

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thomas Hallgren 2005-02-23 14:03:39 Re: Question on TRUNCATE privleges
Previous Message john-paul delaney 2005-02-23 10:38:32 psql: Unicode escape sequence?