御茶義理の人のにっき

CREATE FUNCTION fnc_example_add_date( after_id INT, before_id INT) RETURNS INTEGER AS '
	DECLARE
		temp_rec RECORD;
		div_interval interval;
	BEGIN
		SELECT EXTRACT( \'day\' FROM ad.LoginDate - bd.LoginDate ) as diff_day INTO temp_rec FROM ( SELECT * FROM UserLists WHERE USERID = after_id ) as ad,( SELECT * FROM UserLists WHERE USERID = before_id ) as bd;
		IF temp_rec IS NOT NULL THEN
			div_interval := temp_rec.diff_day * 86400;
			INSERT INTO IntervalTime( Itime ) SELECT LastLoginDate + div_interval FROM LoginLog;
		ELSE
			RETURN 0;
		END IF;
		RETURN 1;
	END
' LANGUAGE 'plpgsql';