On Thu, Jun 05, 2003 at 20:25:32 +0530, [EMAIL PROTECTED] wrote: > > > hi , > > Is there any way to enforce fkeys only on subset of > the table something on the lines of unique partial indexes > > or any work around ? (on update or insert trigger is the only thing i can think of)
If the foreign column is null it isn't checked against the other table. You can probably use this to do what you want. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])