Re: Foreign key constraint for array-field? - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Foreign key constraint for array-field?
Date
Msg-id 48D69B59.6010402@dunslane.net
Whole thread Raw
In response to Re: Foreign key constraint for array-field?  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Foreign key constraint for array-field?  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers

Simon Riggs wrote:
> No, its not possible. Need a trigger.
>
> I think we should support it though. If we extend the relational model
> with arrays then it would be sensible if we support this aspect as
> well. 
>
> Implementation would be fairly straightforward. ri_triggers currently
> assumes a non-array value is being checked, but that could be changed to
> IN(array). Multi-column keys with arrays sound confusing though.
>
>   

What's the syntax going to look like?

cheers

andrew


pgsql-hackers by date:

Previous
From: "Dmitry Koterov"
Date:
Subject: Re: Foreign key constraint for array-field?
Next
From: David Fetter
Date:
Subject: Re: Foreign key constraint for array-field?