Unique indexes in database

2010-04-14 Thread Mateusz Jan Przybylski
Hello, there is a +Key prefix class for unique index for a relation. As far as I understand it, it only works for single attribute of object. Is there a reasonably straightforward way to have an index that requires uniqueness of tuple/list of two or more attributes? Regards, -- dexen /*

Re: Unique indexes in database

2010-04-14 Thread Henrik Sarvell
Check +Aux, it could maybe work for you. Search this mailing list and the documentation. Something I wrote: http://www.prodevtips.com/2008/10/09/pilog-solve-and-the-aux-relation/ /Henrik On Wed, Apr 14, 2010 at 9:58 AM, Mateusz Jan Przybylski dexen.devr...@gmail.com wrote: Hello, there

Re: Unique indexes in database

2010-04-14 Thread Alexander Burger
On Wed, Apr 14, 2010 at 10:32:14AM +0200, Henrik Sarvell wrote: Check +Aux, it could maybe work for you. Yes, +Aux is another option. Didn't think about that. But it requires a second relation defined for that entity, and it causes the creation of a combined key. Cheers, - Alex --

Re: Unique indexes in database

2010-04-14 Thread Mateusz Jan Przybylski
Thank you for extensive answers, Henrik and Alex :) Regards, -- dexen -- UNSUBSCRIBE: mailto:picol...@software-lab.de?subject=unsubscribe