Advice on custom data types

Поиск
Список
Период
Сортировка
От Morgan Kita
Тема Advice on custom data types
Дата
Msg-id 08B420FF5BF7BC42A064212C2EB768801C1090@neutron.verseon.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: .pgpass file
Следующее
От: "Derrick Betts"
Дата:
Сообщение: Select Interval in plpgsql