[V4MD] unique between two fields

[Ivan Smahin]

Hello info,

Saturday, November 5, 2005, 2:24:26 PM, you wrote:

  
 
ivc> eg
ivc> F1 Discipline   F2 Year
ivc>  
ivc> Music   |  2005    --ok
ivc> Music   |  2006    --ok
ivc> Math     |  2005  --  ok
ivc> Music   |  2005    wrong


create table t1 ( f1 string(20), f2 long, m1 string(30) method('f1 || f2') unique )

insert into t1 (f1,f2) values ( 'Music', 2005)
insert into t1 (f1,f2) values ( 'Music', 2006)
insert into t1 (f1,f2) values ( 'Music', 2005)  -- Exception!



-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua