Re: exploiting features of pg to obtain polymorphism maintaining ref. integrity

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: exploiting features of pg to obtain polymorphism maintaining ref. integrity
Date: 2006-10-08 12:09:53
Message-ID: 20061008120953.GB13942@merkur.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Oct 06, 2006 at 11:09:29PM +0200, Ivan Sergio Borgonovo wrote:

> Is there any good documentation, example, tutorial, pamphlet, discussion... to exploit pg features to obtain "polymorphic" behavior without renouncing to referential integrity?

In GNUmed we use it to aggregate text fields over a
range of child tables and for auditing:

http://cvs.savannah.gnu.org/viewcvs/gnumed/gnumed/server/sql/?root=gnumed

look at gmAudit*.sql and gmclinical.sql

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message stevegy 2006-10-08 12:18:05 Re: &nbsp;Hi,&nbsp;For&nbsp;the&
Previous Message Ivan Sergio Borgonovo 2006-10-08 11:57:15 Re: exploiting features of pg to obtain polymorphism