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.