반응형
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'
반응형
'db' 카테고리의 다른 글
[postgresql] unnest(둥지에서 몰아내다), select unnest(array[1,2,3]); 1 row->n rows (0) | 2023.12.18 |
---|---|
[postgresql]STRING_TO_ARRAY('A|B|C|D', '|') -> {A,B,C,D} (0) | 2023.12.18 |
postgreSQL (0) | 2023.11.09 |
mysql 모든 table, key, index...etc 확인 (0) | 2022.05.19 |
mysql change column error (0) | 2022.04.28 |