drop table if exists pricer;create table pricer  (id_price serial, price int, created timestamp);

begin;insert into pricer values(nextval('pricer_id_price_seq'),10,now());commit;
begin;insert into pricer values(nextval('pricer_id_price_seq'),11,now()-interval'1 minute');commit;
begin;insert into pricer values(nextval('pricer_id_price_seq'),11,now()-interval'2 minute');commit;
begin;insert into pricer values(nextval('pricer_id_price_seq'),10,now()-interval'3 minute');commit;
begin;insert into pricer values(nextval('pricer_id_price_seq'),13,now()-interval'4 minute');commit;
begin;insert into pricer values(nextval('pricer_id_price_seq'),14,now()-interval'5 minute');commit;
begin;insert into pricer values(nextval('pricer_id_price_seq'),1,now()-interval'6 minute');commit;
begin;insert into pricer values(nextval('pricer_id_price_seq'),16,now()-interval'7 minute');commit;
begin;insert into pricer values(nextval('pricer_id_price_seq'),16,now()-interval'8 minute');commit;
begin;insert into pricer values(nextval('pricer_id_price_seq'),10,now()-interval'9 minute');commit;

select * from pricer;


delete from pricer where id_price in ( select id_price  from pricer z join (
select rowN.created
     , rowN.price
  from pricer as rowM
inner
  join pricer as rowN
    on rowN.created =
       ( select min(created)
           from pricer
          where created
              > rowM.created )
 where rowN.price - rowM.price=0) foo on z.created=foo.created and z.price=foo.price  );