반응형
SELECT 
  MS.SCHEDULE_ID, 
  SPC."CROP_ID" AS CROP_ID, 
  SPC."CROP_PRODUCT_ID" AS CROP_PRODUCT_ID, 
  SPC."FLOW_ID" AS FLOW_ID, 
  SPC."CROP_NM" AS CROP_NM, 
  SPC."CROP_PRODUCT_NM" AS CROP_PRODUCT_NM, 
  SPC."FLOW_NM" AS FLOW_NM 
FROM 
  MDM_SCHEDULE MS, 
  jsonb_to_recordset(MS.CROP_PRODUCT_FLOW :: jsonb) as SPC(
    "CROP_ID" text, "CROP_PRODUCT_ID" text, 
    "FLOW_ID" text, "CROP_NM" text, "CROP_PRODUCT_NM" text, 
    "FLOW_NM" text
  ) 
WHERE 
  MS.USE_YN = 'Y' 
  AND MS.DEL_YN = 'N'

 

 

반응형

+ Recent posts