W dniu 01.03.2016 o 20:02, Igor Neyman pisze:
[--------------------]
>
>
> It just occured to me: how do I make sure (e.g. force within a database) with the above structure, that a message can have *only one* sender?
> but, allow for multiple recepients?
>
> -R
>
> ____________________________________________________________________________________
>
> If I'm not too late, unique partial index:
>
> CREATE UNIQUE INDEX unique_message_sender (message_id, person_id) WHERE relationship_type = sender;
>
Of cource.
Apparently I'm so twisted after the numerous rewrites of my schema for
this project, that I forget the obvious.
Thenx,
-R