PLPGSQL | timestamp without time zone |
DECLARE p_key alias for $1; p_default alias for $2; v_value timestamp; BEGIN select reg_timestamp into v_value from sl_registry where reg_key = p_key; if not found then v_value = p_default; if p_default notnull then perform registry_set_timestamp(p_key, p_default); end if; else if v_value is null then raise exception 'Slony-I: registry key % is not an timestamp value', p_key; end if; end if; return v_value; END; |