Sunday, September 21, 2008

Re: [HACKERS] Foreign key constraint for array-field?

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?



Sent via pgsql-hackers mailing list (
To make changes to your subscription:

No comments: