Enum JsonTableColumn 

pub enum JsonTableColumn {
    Ordinality {
        name: String,
    },
    Regular {
        name: String,
        ty: ColumnTypeName,
        path: String,
        exists: bool,
        format_json: bool,
        wrapper: bool,
        on_empty: JsonTableOnBehavior,
        on_error: JsonTableOnBehavior,
    },
    Nested {
        path: String,
        columns: Vec<JsonTableColumn>,
    },
}

v7.39 (round 205) — one entry in a JSON_TABLE (or NESTED) COLUMNS list.

Variants

Ordinality

<name> FOR ORDINALITY — 1-based counter within this level.

Fields

name: String

Regular

<name> <type> [FORMAT JSON] PATH '<p>' [WITH WRAPPER] [{DEFAULT <e>|ERROR|NULL} ON EMPTY] [... ON ERROR], or <name> <type> EXISTS [PATH '<p>'].

Fields

name: String

ty: ColumnTypeName

path: String

The column jsonpath; defaults to $.<name> when PATH omitted.

exists: bool

EXISTS [PATH …] — the column is a boolean “did the path match”.

format_json: bool

FORMAT JSON — return the raw jsonb value (not a coerced scalar).

wrapper: bool

WITH [UNCONDITIONAL] WRAPPER — wrap the result in a json array.

on_empty: JsonTableOnBehavior

Behaviour when the path matches nothing (default NULL).

on_error: JsonTableOnBehavior

Behaviour when coercion fails (default NULL).

Nested

NESTED PATH '<p>' COLUMNS (...) — a child level joined per parent row like a LEFT JOIN (a parent with no nested match still emits one row, nested cols NULL).

Fields

path: String

columns: Vec<JsonTableColumn>

Trait Implementations

impl Clone for JsonTableColumn

fn clone(&self) -> JsonTableColumn

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for JsonTableColumn

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl PartialEq for JsonTableColumn

fn eq(&self, other: &JsonTableColumn) -> bool

Equality operator ==.

fn ne(&self, other: &Rhs) -> bool

Inequality operator !=.

impl StructuralPartialEq for JsonTableColumn