Re: foreign key from array element

On 09/17/2012 04:46 PM, Rafal Pietrak wrote:
> Hello the list,
>
> recently I'm cooking a database for an application, that I feel is best
> implemented with tables containing arrays.
>
> I have found some related info here:
> http://archives.postgresql.org/pgsql-hackers/2008-09/msg01356.php
>
> although the initial advice in that thread was: not to use arrays and:
> "learning database best practice".
>
> the thread eventually went into accepting this for implementation:
> http://archives.postgresql.org/pgsql-hackers/2008-09/msg01341.php
>
> Does anyone know if the implementation actually happened since? In which
> version? How does the syntax loook like?

There was some quite recent discussion on ELEMENT foreign keys on the
-hackers list. Try searching pgsql-hackers for ELEMENT foreign key.

See:
   https://commitfest.postgresql.org/action/patch_view?id=775
   https://commitfest.postgresql.org/action/patch_view?id=900

and the linked discussions.

--
Craig Ringer