On Mon, Oct 22, 2012 at 12:08 PM, Tom Lane <t...@sss.pgh.pa.us> 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?
Well, I can't say I'm very happy with the discrepancy between the two syntaxes, but I guess I'm in the minority. Still, I can't help but think it's going to be confusing and hard to remember. If we don't get complaints about it, I'll take that as evidence that the feature isn't being used, rather than evidence that the syntax is satisfactory. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers