postgresql 存储过程返回表

with 的作用是生成一张临时表，在递归查询中应该都用到吧(with recursive t as(sql))

CREATE OR REPLACE FUNCTION getCostAndVm (datacenterid INTEGER) 
   RETURNS TABLE (
      t1 INT4,
			PoweredOffVM BIGINT,
			PoweredOnVM BIGINT,
			Svm BIGINT,
			llvm BIGINT,
			zvm BIGINT
) 
AS $$
BEGIN
   RETURN QUERY
select
	team as t1,
	COUNT(CASE WHEN vi.state = 'Off' THEN 1 ELSE NULL END) as "PoweredOffVM",
	COUNT(CASE WHEN vi.state = 'On' THEN 1 ELSE NULL END) as "PoweredOnVM",
	COUNT(CASE WHEN vi.state = 'Suspended' THEN 1 ELSE NULL END) as "Svm",
	COUNT(CASE WHEN vi.up_time > '1 month'::interval THEN 1 ELSE NULL END) as "llvm",
	COUNT(CASE WHEN vi.off_interval > '60 days'::interval THEN 1 ELSE NULL END) as "zvm"
from dashboard_vm_instance_withteam vi
where vi.datacenter_id=datacenterid
group by datacenter_id ,t1;
END
$$ LANGUAGE 'plpgsql';