registry_set_timestamp(p_value text, p_key timestamp with time zone)

8.91. registry_set_timestamp(p_value text, p_key timestamp with time zone)

Function Properties

Language: PLPGSQL

Return Type: timestamp without time zone

registry_set_timestamp(key, value) Set or delete a registry value

BEGIN
	if p_value is null then
		delete from sl_registry
				where reg_key = p_key;
	else
		lock table sl_registry;
		update sl_registry
				set reg_timestamp = p_value
				where reg_key = p_key;
		if not found then
			insert into sl_registry (reg_key, reg_timestamp)
					values (p_key, p_value);
		end if;
	end if;
	return p_value;
END;