Constraint Syntax Question

From: Adam Sherman <adam(at)tritus(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Constraint Syntax Question
Date: 2003-05-11 22:17:54
Message-ID: 7380000.1052691474@saturn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have a many-to-many relationship between A & B where a B *must* relate to
at least 1 A but an A may have zero Bs.

How do add this using an ALTER TABLE statement?

Thanks,

A.

--
Adam Sherman
Tritus CG Inc.
http://www.tritus.ca/
+1 (613) 797-6819

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Linstruth 2003-05-12 01:05:06 Re: sub select performance
Previous Message David W Noon 2003-05-11 21:10:20 Re: please help construct an SQL query