postgresql json count 질문입니다.

Question

특정 필드에 {&#34;first&#34;:{&#34;A&#34;:&#34;A&#34;,&#34;B&#34;:&#34;B&#34;, &#34;C&#34;:&#34;C&#34; },&#34;second&#34;:{&#34;A&#34;:&#34;A&#34;,&#34;B&#34;:&#34;B&#34;,&#34;C&#34;:&#34;C&#34; }} 이와같은 json 데이터가 있는데 1차원 갯수 즉 2라는 값을 찾아야되는데 어떻게 해야되나요? https://stackoverflow.com/questions/38511845/postgresql-how-to-get-the-count-of-elements-in-a-column-list 찾았는데 json object 형식이지 json array가 아니라 cannot get array length of a non-array 오류가 나는것 같습니다 참고로 지금 들어있는 데이터를 {[&#34;first&#34;:{&#34;A&#34;:&#34;A&#34;,&#34;B&#34;:&#34;B&#34;, &#34;C&#34;:&#34;C&#34; }],[&#34;second&#34;:{&#34;A&#34;:&#34;A&#34;,&#34;B&#34;:&#34;B&#34;,&#34;C&#34;:&#34;C&#34; }]} 이렇게 json_array 로 바꿀수 없는 상황입니다

카스마당 · Answer

select array_length(array_agg(A.key), 1) from ( select json_object_keys('{&#34;first&#34;:{&#34;A&#34;:&#34;A&#34;,&#34;B&#34;:&#34;B&#34;,&#34;C&#34;:&#34;C&#34;},&#34;second&#34;:{&#34;A&#34;:&#34;A&#34;,&#34;B&#34;:&#34;B&#34;,&#34;C&#34;:&#34;C&#34;}, &#34;third&#34;:{&#34;A&#34;:&#34;A&#34;,&#34;B&#34;:&#34;B&#34;,&#34;C&#34;:&#34;C&#34;}}') as key ) A;SELECT count(*) FROM jsonb_object_keys('{&#34;first&#34;:{&#34;A&#34;:&#34;A&#34;,&#34;B&#34;:&#34;B&#34;,&#34;C&#34;:&#34;C&#34;},&#34;second&#34;:{&#34;A&#34;:&#34;A&#34;,&#34;B&#34;:&#34;B&#34;,&#34;C&#34;:&#34;C&#34;}, &#34;third&#34;:{&#34;A&#34;:&#34;A&#34;,&#34;B&#34;:&#34;B&#34;,&#34;C&#34;:&#34;C&#34;}}'::jsonb); 좌표 https://stackoverflow.com/questions/36171737/how-to-count-setof-number-of-keys-of-json-in-postgresql pgsql 없어서...ㅠㅠ https://rextester.com/l/postgresql_online_compiler https://extendsclass.com/postgresql-online.html

와일드밤바 · Answer

앗 감사힙니다.

postgresql json count 질문입니다.

2개의 답변

#count 목록