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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend