[POSTGRES] SELECT 배열 & 배열 > 행데이터로 변환
SELECT ARRAY['2020','2021','2022','2023'] SELECT unnest(ARRAY['2020','2021','2022','2023']) 연도별 월 조회하기 select a.year, b.month from (SELECT unnest(ARRAY['2020','2021','2022','2023']) as year) a , (select unnest(ARRAY['01','02','03','04']) as month) b
PROGRAMMING/DATABASE
2021. 9. 3. 11:04
