XmlTableColumn in sqlparser::ast

XmlTableColumn in sqlparser::ast - Rust

Struct XmlTableColumn

pub struct XmlTableColumn {
    pub name: Ident,
    pub option: XmlTableColumnOption,
}

Expand description

A single column definition in XMLTABLE

COLUMNS
    id int PATH '@id',
    ordinality FOR ORDINALITY,
    "COUNTRY_NAME" text,
    country_id text PATH 'COUNTRY_ID',
    size_sq_km float PATH 'SIZE[@unit = "sq_km"]',
    size_other text PATH 'concat(SIZE[@unit!="sq_km"], " ", SIZE[@unit!="sq_km"]/@unit)',
    premier_name text PATH 'PREMIER_NAME' DEFAULT 'not specified'

The name of the column.

Column options: type/path/default or FOR ORDINALITY