1 CREATE OR REPLACE FUNCTION migration_tools.attempt_hz_date (TEXT,TEXT) RETURNS DATE AS $$
3 attempt_value ALIAS FOR $1;
4 fail_value ALIAS FOR $2;
8 EXECUTE E'SELECT (\'1970-01-01\'::date + \'' || attempt_value || E' days\'::interval)::date AS a;'
15 EXECUTE 'SELECT ' || quote_literal(fail_value) || '::date AS a;'
20 $$ LANGUAGE PLPGSQL STRICT STABLE;