"Tom Lane" <[EMAIL PROTECTED]> writes: > NikhilS <[EMAIL PROTECTED]> writes: >> I just now realized that even though we allow the above. We do not allow: > >> pg=# create table t1 (a int, b int, unique(a+b)); > >> Any specific reason for this behaviour? > > It'd be contrary to SQL spec. The UNIQUE constraint takes a list of > column names, full stop.
Does the SQL spec actually specify what happens if you provide an non-compliant table definition like this? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate