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? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers