On Mon, May 9, 2011 at 2:12 PM, Grzegorz Szpetkowski <[email protected]> wrote: > "NOTE 30 — If MATCH FULL or MATCH PARTIAL is specified for a > referential constraint and if the referencing table has only one > column specified in <referential constraint definition> for that > referential constraint, or if the referencing table has more than one > specified column for that <referential constraint definition>, but > none of those columns is nullable, then the effect is the same as if > no > <match type> were specified." > > I found that in SQL:2003 draft, so in above case MATCH FULL is > syntactically ok, but rather confusing and effectively do nothing > (maybe just impression purpose).
I guess we could remove it, but I don't think it's really doing any harm. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
