Modelling relationships

From: Konstantinos Vassiliadis <vassilik(at)p03(dot)cs(dot)man(dot)ac(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Modelling relationships
Date: 1998-07-18 16:29:12
Message-ID: Pine.LNX.3.95.980718172048.20098E-100000@p03.cs.man.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
I am wondering how Postgres can support the modelling of various
relationship types apart from defining primary and foreign keys which is
the pure relational solution.
I am doing a project to explore the capabilities of an Object Relational
system just like Postgres, and compare them with those of a pure relational
system. I am doing this using a Protein Interactions database (biology
stuff..)
I am looking at how to model various relationship types
for example, a table type A is related to many table types B. For this
case, I defined
create table B
(...........)

create table A
(manyBs B)

a)When inserting values into column 'manyBs' it stores what looks to me
as
a pointer (eg values 2352192 of type B). How can I use this value to
perform useful queries?
b)Does Postgres support REFerence column types to represent one-to-many
relationships as a substitute for primary/foreign keys? If yes, does it
have a DEREF operator to dereference a value of REF type and thus access
the object pointed to by REF?

If somebody came across these before, could he/she give me some help?

Kostas Vassiliadis

Browse pgsql-sql by date

  From Date Subject
Next Message Konstantinos Vassiliadis 1998-07-18 16:33:11 Modelling relationships (fwd)
Previous Message Konstantinos Vassiliadis 1998-07-18 14:34:29 Inserting values into setof type attributes