SGJP / Kuznia

delete_v.sql 1.1 KB
1 2 3 4 5 6 7 8 
SELECT set_config('var.user_id', '0', false);
delete FROM odsylacze WHERE l_id_do in (select id from leksemy where ("leksemy"."slownik" = 'Morfologik' and pos in ('v', 'ger', 'pact', 'ppas', 'appas')));
delete FROM odsylacze WHERE l_id_od in (select id from leksemy where ("leksemy"."slownik" = 'Morfologik' and pos in ('v', 'ger', 'pact', 'ppas', 'appas')));
delete FROM odmieniasie WHERE l_id in (select id from leksemy where ("leksemy"."slownik" = 'Morfologik' and leksemy.pos in ('v', 'ger', 'pact', 'ppas', 'appas')));
delete FROM leksemy_w_slownikach WHERE l_id in (select id from leksemy where leksemy.pos in ('v', 'ger', 'pact', 'ppas', 'appas') and slownik = 'Morfologik');
delete FROM leksemy_w_slownikach WHERE l_id in (select id from leksemy where leksemy.pos in ('v', 'ger', 'pact', 'ppas', 'appas')) and slownik = 'Morfologik';
delete FROM kwalifikatory_leksemow WHERE lexeme_id in (select id from leksemy where leksemy.pos in ('v', 'ger', 'pact', 'ppas', 'appas') and slownik = 'Morfologik');
delete FROM "leksemy" WHERE ("leksemy"."slownik" = 'Morfologik' and leksemy.pos in ('v', 'ger', 'pact', 'ppas', 'appas'));