Re: [SQL] simulating partial fkeys.. [ATTN Developers please]

2003-06-07 Thread Stephan Szabo
On Fri, 6 Jun 2003, Richard Huxton wrote: > On Thursday 05 Jun 2003 3:55 pm, [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 > > I'm afraid not (AFAIK). What might be a solution in your ca

Re: [SQL] simulating partial fkeys.. [ATTN Developers please]

2003-06-06 Thread Richard Huxton
On Thursday 05 Jun 2003 3:55 pm, [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 I'm afraid not (AFAIK). What might be a solution in your case is to define another unique index. For example, you m