Skip site navigation (1) Skip section navigation (2)

Advice on custom data types

From: "Morgan Kita" <mkita(at)verseon(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Advice on custom data types
Date: 2005-03-22 01:49:16
Message-ID: 08B420FF5BF7BC42A064212C2EB768801C1090@neutron.verseon.com (view raw or flat)
Thread:
Lists: pgsql-novice
In my initial database schema I have certain relational tables that could strongly be thought of as objects. As an example one table might hold a bunch of related points(x,y,z) where the rows could be grouped by a foreign key to another table. 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 querying on the fields contained in the possible objects, nor would I be indexing on them. It would essentially just be storing them 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

Next:From: Derrick BettsDate: 2005-03-22 03:24:21
Subject: Select Interval in plpgsql
Previous:From: John DeSoiDate: 2005-03-22 00:31:07
Subject: Re: .pgpass file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group