[Solved] What will be the output of this query?SELECT jsonb_array_length('[{"a":1},{"b":2}]'::jsonb); — Ans: 2 | PostgreSQL

PostgreSQL - JSON and JSONB

What will be the output of this query?
SELECT jsonb_array_length('[{"a":1},{"b":2}]'::jsonb);

A2

B1

CError: invalid function

D0

Step-by-Step Solution

Solution:

Step 1: Understand jsonb_array_length function
This function returns the number of elements in a JSONB array.
Step 2: Analyze input JSONB array
The input is an array with two objects: {"a":1} and {"b":2}.
Final Answer:
2 -> Option A
Quick Check:
jsonb_array_length counts array elements correctly [OK]

Quick Trick: Use jsonb_array_length to count JSON array elements [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What will be the output of this query?