Advice on custom data types - Mailing list pgsql-novice

From Morgan Kita
Subject Advice on custom data types
Date
Msg-id 08B420FF5BF7BC42A064212C2EB768801C1090@neutron.verseon.com
Whole thread Raw
List pgsql-novice
In my initial database schema I have certain relational tables that could strongly be thought of as objects. As an
exampleone table might hold a bunch of related points(x,y,z) where the rows could be grouped by a foreign key to
anothertable. Anotherwords each set of points belongs to one row in another table.  

So from what I have been reading here in the forums its usually best to avoid custom data types, but I would not be
queryingon the fields contained in the possible objects, nor would I be indexing on them. It would essentially just be
storingthem and extracting them as needed. Would this be a good case for a custom data type, written as a C struct? 

pgsql-novice by date:

Previous
From: John DeSoi
Date:
Subject: Re: .pgpass file
Next
From: "Derrick Betts"
Date:
Subject: Select Interval in plpgsql