SQL結果： 頁面展示結果： JS： data.rows.forEach(function(row,e){ var ppRow=row.fduty+row.fline+row.fprocess; rowIndex = $.inArray(ppRow,rowNums); if(rowIndex==-1){ rowNums.push(ppRow); var newRow1={fduty:row.fduty,fline:row.fline,fprocess:row.fprocess,fproduct:row.f

1、procedure 1.1 create: CREATE OR REPLACE PROCEDURE myProc001(site character varying, fweek integer) LANGUAGE plpgsql AS $procedure$ BEGIN sqls;--only execute , no return END; $procedure$; 1.2 call: call myProc001('ooodt1 08:00:00',...

select fdate::int,iotype,duty,process,0,sum(fqty),0,0, sum(fqty) filter(where fhour='0'),sum(fqty) filter(where fhour='1'), sum(fqty) filter(where fhour='2'),sum(fqty) filter(where fhour='3'), sum(fqty) filter(where ...