What values import sent

What values import sent

Messages from import (source = 'import') in raw_inbox always contain valid JSON, but the value inside is not necessarily an object. Unpack these parcels and show what kind of JSON value arrived in each one. What to return: - msg_id — the message ID - json_type — the value type as PostgreSQL names it: object, array, string, number, boolean or null Keep in mind: - body is stored as plain text - include only messages with source = 'import' - leave out other sources: some of their bodies do not parse as JSON Sort by msg_id ascending.

Row order matters

PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid