Le vendredi 10 février 2012 à 14:19 -0500, David Johnston a écrit :
> One possibility is to add a "version" field (integer) and combine evenement and version to create the unique. I'd
alsocreate a partial unique on evenement/annule to ensure you do not make more than one active version.
>
Hi David,
I don't find this solution very much different from using a surrogate
key?
Except that you then have to code it yourself, instead of using the
built-in serial.
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des sinistres et des contentieux pour le service juridique