"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


Reply via email to