| 19 | | INSERT INTO stages (sop_id,procid,ptstid,prn_id,stdver,ptstnm,ptsttp,orgarr,params,end___,duratn,is_fix,fixdat,fixper,orunid,sysdat,is_act,errlog,assign,props_,in_set,outset,isinst,actdat,state_,trbyev,prcref,allow_,commen) SELECT nextval('stages_sop_id_seq'::regclass),procid,ptstid, prn_id, stdver,ptstnm,ptsttp, array[orgarr] as orgarr, params,end___,duratn,is_fix,fixdat,fixper,orunid,sysdat,is_act,errlog,assign,props_,in_set,outset,isinst,actdat,state_,trbyev,prcref,allow_,commen |
| | 19 | INSERT INTO stages (sop_id,procid,ptstid,prn_id,stdver,ptstnm,ptsttp,orgarr,params,end___,duratn,is_fix,fixdat,fixper,orunid,sysdat,is_act,errlog,assign,props_,in_set,outset,isinst,actdat,state_,trbyev,prcref,allow_,commen) |
| | 20 | SELECT nextval('stages_sop_id_seq'::regclass),procid,ptstid, prn_id, stdver,ptstnm,ptsttp, array[orgarr] as orgarr, params,end___,duratn,is_fix,fixdat,fixper,orunid,sysdat,is_act,errlog,assign,props_,in_set,outset,isinst,actdat,state_,trbyev,prcref,allow_,commen |
| 20 | 21 | FROM ( |
| 21 | 22 | select sop_id,procid,ptstid, sop_id as prn_id, stdver,ptstnm,ptsttp, unnest(orgarr) as orgarr, params,end___,duratn,is_fix,fixdat,fixper,orunid,sysdat,is_act,errlog,assign,props_,in_set,outset,TRUE as isinst,actdat,state_,trbyev,prcref,allow_,commen |
