Re: [HACKERS] [PATCH] Support for Array ELEMENT Foreign Keys

[Andrew Dunstan]

On 10/22/2012 12:08 PM, Tom Lane wrote:

I wrote:

I tested, and indeed this seems to work:
        CREATE TABLE t1 (c int[] WHERE EACH ELEMENT REFERENCES t2);
and it's perfectly sensible from an English-grammar standpoint too.
If we take that, how would we spell the table-constraint case exactly?
Grammatically I'd prefer
        FOREIGN KEY (foo, EACH ELEMENT OF bar) REFERENCES

Are people happy with these syntax proposals, or do we need some other
color for the bikeshed?

I can live with it, although the different spelling is slightly jarring.

cheers

andrew



--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers