Postgres row expiration

CREATE TABLE expire_table (
    timestamp timestamp NOT NULL DEFAULT NOW(),
    name TEXT NOT NULL
);

INSERT INTO expire_table (name) VALUES ('a');
INSERT INTO expire_table (name) VALUES ('b');
INSERT INTO expire_table (name) VALUES ('c');

select * from expire_table;
         timestamp          | name 
----------------------------+------
 2014-09-26 15:33:43.243356 | a
 2014-09-26 15:33:45.222202 | b
 2014-09-26 15:33:47.347131 | c
(3 rows)

CREATE FUNCTION expire_table_delete_old_rows() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
BEGIN
  DELETE FROM expire_table WHERE timestamp < NOW() - INTERVAL '1 minute';
  RETURN NEW;
END;
$$;

CREATE TRIGGER expire_table_delete_old_rows_trigger
    AFTER INSERT ON expire_table
    EXECUTE PROCEDURE expire_table_delete_old_rows();

INSERT INTO expire_table (name) VALUES ('d');

select * from expire_table;
         timestamp          | name 
----------------------------+------
 2014-09-26 15:36:56.132596 | d
(1 row)

Source: stackoverflow.com

Similar codes

0 vote345 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
1 vote473 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
1 vote326 views1 answer
Ubuntu access database from terminal
SQL
1 vote325 views1 answer
Oracle duration between timestamps
SQL
0 vote313 views1 answer
Time mysql w3
SQL
9 votes319 views3 answers
Oracle undo usage by session
SQL
0 vote342 views1 answer
What is top n result in sql
SQL
0 vote324 views2 answers
Auto increment column in mysql query results
SQL
1 vote344 views1 answer
Sql check roles
SQL
7 votes305 views1 answer
Grant schema permissions postgres
SQL