For me, foreign keys for arrays would be incredibly helpful. For simple checkbox-type options, it's _much_ simpler to just put them in an array, and I work with a UI that can handle the arrays well. I do hope this makes it into Postgresql someday! In the meantime, I've mostly sacrificed the referential integrity in favor of the convenience. Just my two cents.
Cheers, Ken -- AGENCY Software A Free Software data system By and for non-profits *http://agency-software.org/ <http://agency-software.org/>* *https://agency-software.org/demo/client <https://agency-software.org/demo/client>* [email protected] (253) 245-3801 Subscribe to the mailing list <[email protected]?body=subscribe> to learn more about AGENCY or follow the discussion.
