Enum PLpgSQLStmt 

pub enum PLpgSQLStmt {
    Block(PLpgSQLBlock),
    Assign {
        target: usize,
        expr: Expr,
    },
    If {
        cond: Expr,
        then_body: Vec<PLpgSQLStmt>,
        elsifs: Vec<(Expr, Vec<PLpgSQLStmt>)>,
        else_body: Option<Vec<PLpgSQLStmt>>,
    },
    Case {
        t_expr: Option<Expr>,
        t_varno: Option<usize>,
        arms: Vec<(Expr, Vec<PLpgSQLStmt>)>,
        else_body: Option<Vec<PLpgSQLStmt>>,
    },
    Loop {
        label: Option<String>,
        body: Vec<PLpgSQLStmt>,
    },
    While {
        label: Option<String>,
        cond: Expr,
        body: Vec<PLpgSQLStmt>,
    },
    ForI {
        label: Option<String>,
        var: usize,
        lower: Expr,
        upper: Expr,
        step: Option<Expr>,
        reverse: bool,
        body: Vec<PLpgSQLStmt>,
    },
    ForQuery {
        label: Option<String>,
        target: IntoTarget,
        query: Statement,
        body: Vec<PLpgSQLStmt>,
    },
    Exit {
        is_exit: bool,
        label: Option<String>,
        cond: Option<Expr>,
    },
    Return {
        value: Option<PLpgSQLReturnValue>,
    },
    ReturnNext {
        value: Option<PLpgSQLReturnValue>,
    },
    ReturnQuery {
        query: Statement,
    },
    ReturnQueryExecute {
        query: Expr,
        params: Vec<Expr>,
    },
    Raise {
        level: RaiseLevel,
        condition: Option<String>,
        message: Option<String>,
        params: Vec<Expr>,
    },
    ExecSQL {
        stmt: Statement,
        into: Option<IntoTarget>,
        strict: bool,
    },
    DynExecute {
        query: Expr,
        params: Vec<Expr>,
        into: Option<IntoTarget>,
        strict: bool,
    },
    Perform {
        query: Statement,
    },
    OpenCursor {
        cursor: usize,
        arguments: Vec<PLpgSQLCursorArgument>,
    },
    FetchCursor {
        cursor: usize,
        target: IntoTarget,
        direction: i64,
        count: i64,
    },
    CloseCursor {
        cursor: usize,
    },
    GetDiagnostics {
        items: Vec<(String, usize)>,
    },
}

Executable PL/pgSQL statement.

Variants

Block(PLpgSQLBlock)

Assign

target := expr (also =). target indexes the datum table.

Fields

target: usize

expr: Expr

If

Fields

cond: Expr

then_body: Vec<PLpgSQLStmt>

elsifs: Vec<(Expr, Vec<PLpgSQLStmt>)>

else_body: Option<Vec<PLpgSQLStmt>>

Case

CASE statement. Simple form carries t_expr + the temporary datum the compiler references from each rewritten WHEN.

Fields

t_expr: Option<Expr>

t_varno: Option<usize>

arms: Vec<(Expr, Vec<PLpgSQLStmt>)>

else_body: Option<Vec<PLpgSQLStmt>>

Loop

Fields

label: Option<String>

body: Vec<PLpgSQLStmt>

While

Fields

label: Option<String>

cond: Expr

body: Vec<PLpgSQLStmt>

ForI

FOR i IN [REVERSE] lower..upper [BY step] LOOP.

Fields

label: Option<String>

var: usize

lower: Expr

upper: Expr

step: Option<Expr>

reverse: bool

body: Vec<PLpgSQLStmt>

ForQuery

FOR target IN <query> LOOP.

Fields

label: Option<String>

target: IntoTarget

query: Statement

body: Vec<PLpgSQLStmt>

Exit

EXIT (is_exit) or CONTINUE, optionally labelled and conditional (WHEN cond).

Fields

is_exit: bool

label: Option<String>

cond: Option<Expr>

Return

Fields

value: Option<PLpgSQLReturnValue>

ReturnNext

RETURN NEXT [expr] - bare form emits the current OUT / TABLE column values.

Fields

value: Option<PLpgSQLReturnValue>

ReturnQuery

Fields

query: Statement

ReturnQueryExecute

Fields

query: Expr

params: Vec<Expr>

Raise

Fields

level: RaiseLevel

condition: Option<String>

message: Option<String>

params: Vec<Expr>

ExecSQL

Embedded SQL statement, optionally INTO [STRICT] target.

Fields

stmt: Statement

into: Option<IntoTarget>

strict: bool

DynExecute

EXECUTE <string> [INTO [STRICT] target] [USING params].

Fields

query: Expr

params: Vec<Expr>

into: Option<IntoTarget>

strict: bool

Perform

Fields

query: Statement

OpenCursor

Fields

cursor: usize

arguments: Vec<PLpgSQLCursorArgument>

FetchCursor

Fields

cursor: usize

target: IntoTarget

direction: i64

count: i64

CloseCursor

Fields

cursor: usize

GetDiagnostics

GET DIAGNOSTICS var = KIND [, ...] as (kind, target datum).

Fields

items: Vec<(String, usize)>

Trait Implementations

impl Clone for PLpgSQLStmt

fn clone(&self) -> PLpgSQLStmt

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for PLpgSQLStmt

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

Formats the value using the given formatter.