On Monday, October 22, 2012 06:08:32 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?
Except that I'd prefer a WHERE in the table-constraint case as well for consistencies sake I am unsurprisingly happy with the proposal. Greetings, Andres -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
