Postgresql：表约束和列约束之间的差异

概述摘自pgsql 8.4 docs：“[…]列约束只是在约束只影响一列时使用的符号方便.” 这个有效的sql怎么样呢？ DROP TABLE IF EXISTS test;CREATE TABLE test(id integer CONSTRAINT PK_test PRIMARY KEY CONSTRAINT nenull NOT NULL CHECK (id3>=id2) --the c 摘自pgsql 8.4 docs：“[…]列约束只是在约束只影响一列时使用的符号方便.”
这个有效的sql怎么样呢？

DROP table IF EXISTS test;CREATE table test(ID integer CONSTRAINT PK_test PRIMARY KEY  CONSTRAINT nenull NOT NulL CHECK (ID3>=ID2) --the check constraint affects two columns none of which is ID,ID2 integer,ID3 integer);

摘录似乎只适用于PRIMARY KEY和FOREIGN KEY约束,这些约束只应影响声明约束的同一行上的列,如Catcall所述

解决方法 Elsewhere in the docs . .

We say that the first two constraints are column constraints,whereas
the third one is a table constraint because it is written separately
from any one column deFinition. Column constraints can also be written
as table constraints,while the reverse is not necessarily possible,
since a column constraint is supposed to refer to only the column
it is attached to. (Postgresql doesn’t enforce that rule,but you should follow it if you want your table deFinitions to work with other database systems.)

总结

以上是内存溢出为你收集整理的Postgresql：表约束和列约束之间的差异全部内容，希望文章能够帮你解决Postgresql：表约束和列约束之间的差异所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。