Re: foreign keys for array/period contains relationships
Peter Eisentraut <peter_e@gmx.net>
From: Peter Eisentraut <peter_e@gmx.net>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Greg Stark <gsstark@mit.edu>, pgsql-hackers@postgresql.org
Date: 2010-10-26T19:09:01Z
Lists: pgsql-hackers
On tis, 2010-10-26 at 11:53 -0700, Jeff Davis wrote: > Case #2 is the strange one, I think. It's not actually just an > adaptation of #1. #1 requires that all elements of the array have a > corresponding PK value; but #2 just requires that one of them does. > Peter, can you clarify case #2? Did you have a use case in mind? [ That's the period references timestamp case. ] You're right, it's probably not useful.