-- Table: deletemasivo

-- DROP TABLE deletemasivo;

CREATE TABLE deletemasivo
(
  id integer,
  nombre text
)
WITHOUT OIDS;
ALTER TABLE deletemasivo OWNER TO postgres;
insert into deletemasivo values(1,'text1');
insert into deletemasivo values(2,'text2');
insert into deletemasivo values(3,'text3');
insert into deletemasivo values(4,'text4');
insert into deletemasivo values(5,'text5');
insert into deletemasivo values(6,'text6');
insert into deletemasivo values(7,'text7');
insert into deletemasivo values(8,'text8');
insert into deletemasivo values(9,'text9');
insert into deletemasivo values(10,'text10');
insert into deletemasivo values(11,'text11');
insert into deletemasivo values(12,'text12');
insert into deletemasivo values(13,'text13');
insert into deletemasivo values(14,'text14');
insert into deletemasivo values(15,'text15');
insert into deletemasivo values(16,'text16');
insert into deletemasivo values(17,'text17');
insert into deletemasivo values(18,'text18');
insert into deletemasivo values(19,'text19');
insert into deletemasivo values(20,'text20');
insert into deletemasivo values(21,'text21');
insert into deletemasivo values(22,'text22');
insert into deletemasivo values(23,'text23');
insert into deletemasivo values(24,'text24');
insert into deletemasivo values(25,'text25');
insert into deletemasivo values(26,'text26');
insert into deletemasivo values(27,'text27');
insert into deletemasivo values(28,'text28');
insert into deletemasivo values(29,'text29');
insert into deletemasivo values(30,'text30');
insert into deletemasivo values(31,'text31');
insert into deletemasivo values(32,'text32');
insert into deletemasivo values(33,'text33');
insert into deletemasivo values(34,'text34');
insert into deletemasivo values(35,'text35');
insert into deletemasivo values(36,'text36');
insert into deletemasivo values(37,'text37');
insert into deletemasivo values(38,'text38');

-- Table: otratabla

-- DROP TABLE otratabla;

CREATE TABLE otratabla
(
  id2 integer,
  nombre text
)
WITHOUT OIDS;
ALTER TABLE deletemasivo OWNER TO postgres;

insert into otratabla values(1,'text1');
insert into otratabla values(2,'text2');
insert into otratabla values(3,'text3');
insert into otratabla values(4,'text4');
insert into otratabla values(5,'text5');
insert into otratabla values(6,'text6');
insert into otratabla values(7,'text7');
insert into otratabla values(8,'text8');
insert into otratabla values(9,'text9');


select * from deletemasivo;

-- Delete con error pero que deja ejecutarlo

delete from deletemasivo where id in (select id from otratabla);


-- Forma correcta para evitar errores

delete from deletemasivo using otratabla where deletemasivo.id = otratabla.id2;