Cam pe la 02/17/2005 02:30 PM, cristi scrise:

>S-a rezolvat.
>
>create sequence test increment by 1 start with 1 maxvalue 10000 nocycle;
>create trigger test_xxx before insert on test1
>for each row
>begin
>select test.nextval into :new.ID from dual;
>end;
>
>
>PS.
>Parca era mai usor in postgres....
>  
>

...si mult mai usor in mysql ;)



--- 
Detalii despre listele noastre de mail: http://www.lug.ro/


Raspunde prin e-mail lui