SGJP / Kuznia

delete_adj.sql 999 Bytes
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 ('adj', 'adjcom')));
delete FROM odsylacze WHERE l_id_od in (select id from leksemy where ("leksemy"."slownik" = 'Morfologik' and leksemy.pos in ('adj', 'adjcom')));
delete FROM odmieniasie WHERE l_id in (select id from leksemy where ("leksemy"."slownik" = 'Morfologik' and leksemy.pos in ('adj', 'adjcom')));
delete FROM leksemy_w_slownikach WHERE l_id in (select id from leksemy where leksemy.pos in ('adj', 'adjcom') and slownik = 'Morfologik');
delete FROM leksemy_w_slownikach WHERE l_id in (select id from leksemy where leksemy.pos in ('adj', 'adjcom')) and slownik = 'Morfologik';
delete FROM kwalifikatory_leksemow WHERE lexeme_id in (select id from leksemy where leksemy.pos in ('adj', 'adjcom') and slownik = 'Morfologik');
delete FROM "leksemy" WHERE ("leksemy"."slownik" = 'Morfologik' and leksemy.pos in ('adj', 'adjcom'));