News for hackers. Stuff that matters.

A comment on PostgreSQL Features You May Not Have Tried but Should. Parent comment

Re:PostgreSQL Features You May Not Have Tried but Should by the_duke on Wednesday June 20, 2018 @01:38PM (#17357622)
Very convenient, I often use them. There's really no reason not to if your data structure is appropriate.

The only drawback for me is that you can't have arrays of foreign keys. (You could of course just store an array of the key values, but without the integrity checks).

[ Parent | on HN ]
Re:PostgreSQL Features You May Not Have Tried but Should by petepete on Wednesday June 20, 2018 @02:03PM (#17357913)
Isn't an associative table the better option here? It would take a lot of the headaches out of dealing with arrays and constraints (ie, duplicates, limits on relationships) while keeping joins simple.
[ Parent | on HN ]