2020年06月12日

文字列を分割 split する方法






SELECT mix_key,
SPLIT_PART(mix_key,'_',1) As F1,
SPLIT_PART(mix_key,'_',2) As F2,
SPLIT_PART(mix_key,'T_',1) As F3
FROM public.sttm_close_1
limit 10

SELECT mix_key,
SPLIT_PART(mix_key,'_',1) As F1,
SPLIT_PART(mix_key,'_',2) As F2,
SPLIT_PART(mix_key,'_',3) As F3,
SPLIT_PART(mix_key,'_',4) As F4
FROM public.sttm_close_1
limit 10

posted by a23 at 16:55| Comment(0) | PostgreSQL