JSON extract text

JSON text extraction operator.

Returns the selected JSON value encoded as a blob or text-like binary value.

Category: extraction

SQL symbol: ->>

Example

SELECT '{"index": 1}' ->> 'index';

Signatures

• blob ->> blob → blob
• blob ->> varchar → blob
• jsonb ->> blob → blob
• jsonb ->> varchar → blob
• struct ->> blob → blob
• struct ->> varchar → blob
• varchar ->> blob → blob
• varchar ->> varchar → blob

Types

• Left: blob, jsonb, struct, varchar
• Right: blob, varchar
• Result: blob