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>,
    },
    ForDynamic {
        label: Option<String>,
        target: IntoTarget,
        query: Expr,
        params: Vec<Expr>,
        body: Vec<PLpgSQLStmt>,
    },
    ForCursor {
        label: Option<String>,
        target: usize,
        cursor: usize,
        arguments: Vec<PLpgSQLCursorArgument>,
        body: Vec<PLpgSQLStmt>,
    },
    ForeachArray {
        label: Option<String>,
        target: usize,
        slice: usize,
        expr: Expr,
        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>,
    },
    Assert {
        condition: Expr,
        message: Option<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,
        open: PLpgSQLCursorOpen,
    },
    FetchCursor {
        cursor: usize,
        target: IntoTarget,
        direction: CursorDirection,
        count: PLpgSQLCursorCount,
    },
    MoveCursor {
        cursor: usize,
        direction: CursorDirection,
        count: PLpgSQLCursorCount,
    },
    CloseCursor {
        cursor: usize,
    },
    Commit {
        chain: bool,
    },
    Rollback {
        chain: bool,
    },
    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>

ForDynamic

FOR target IN EXECUTE query [USING params] LOOP.

Fields

label: Option<String>

target: IntoTarget

query: Expr

params: Vec<Expr>

body: Vec<PLpgSQLStmt>

ForCursor

FOR recordvar IN bound_cursor [(arguments)] LOOP.

Fields

label: Option<String>

target: usize

cursor: usize

arguments: Vec<PLpgSQLCursorArgument>

body: Vec<PLpgSQLStmt>

ForeachArray

FOREACH target [SLICE n] IN ARRAY expression LOOP.

Fields

label: Option<String>

target: usize

slice: usize

expr: Expr

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>

Assert

ASSERT condition [, message].

Fields

condition: Expr

message: Option<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

open: PLpgSQLCursorOpen

FetchCursor

Fields

cursor: usize

target: IntoTarget

direction: CursorDirection

count: PLpgSQLCursorCount

MoveCursor

Fields

cursor: usize

direction: CursorDirection

count: PLpgSQLCursorCount

CloseCursor

Fields

cursor: usize

Commit

Procedural COMMIT [AND [NO] CHAIN].

Fields

chain: bool

Rollback

Procedural ROLLBACK [AND [NO] CHAIN].

Fields

chain: bool

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.