Exponential backoff with postgreSQL

exponential-backoff.sql

/*
  Given a table containing at least a column for the number of errors (with no success in between) and 
  frequently calling the following select will provide the candidates for a retry using an exponential backoff.
*/

SELECT * FROM retryable_error WHERE 
  CURRENT_TIMESTAMP > (last_retry + CAST(CONCAT(CAST(POWER(2, error_count) AS text), 's') AS INTERVAL))