Skip to main content

PlPgSqlStmt

Enum PlPgSqlStmt 

Source
pub enum PlPgSqlStmt {
    Assign {
        target: AssignTarget,
        value: Expr,
    },
    Return(ReturnTarget),
    If {
        branches: Vec<(Expr, Vec<PlPgSqlStmt>)>,
        else_branch: Vec<PlPgSqlStmt>,
    },
    Raise {
        level: RaiseLevel,
        message: String,
        args: Vec<Expr>,
    },
    EmbeddedSql(Box<Statement>),
}

Variants§

§

Assign

NEW.col := expr; or OLD.col := expr;. OLD is parsed for clarity in error reporting (PG also forbids it) — the executor errors with a clear “OLD is read-only” message.

Fields

§value: Expr
§

Return(ReturnTarget)

RETURN <target>; — trigger functions canonically return NEW / OLD / NULL; v7.12.4 also accepts a bare expression for forward compatibility with scalar UDFs.

§

If

v7.12.6 — IF cond THEN body [ELSIF cond THEN body]* [ELSE body] END IF;. Branches are tried in order; first truthy condition wins; the optional ELSE runs when no condition matched.

Fields

§branches: Vec<(Expr, Vec<PlPgSqlStmt>)>
§else_branch: Vec<PlPgSqlStmt>
§

Raise

v7.12.6 — RAISE <level> '<fmt>' [, args]*;. Level is one of NOTICE / WARNING / INFO / LOG / DEBUG (logging — observable side effect only) or EXCEPTION (aborts the trigger and propagates as an error). v7.12.6 supports the basic format-string substitution PG uses (% placeholders consumed positionally).

Fields

§message: String
§args: Vec<Expr>
§

EmbeddedSql(Box<Statement>)

v7.12.6 — embedded SQL statement inside the trigger body (INSERT INTO …, UPDATE …, DELETE FROM …, SELECT …). NEW.col / OLD.col references inside the embedded statement’s expression tree are substituted with the current trigger context before the engine re-executes the statement. Recursion depth into nested triggers is bounded by the engine’s existing trigger-fire guard.

Trait Implementations§

Source§

impl Clone for PlPgSqlStmt

Source§

fn clone(&self) -> PlPgSqlStmt

Returns a duplicate of the value. Read more
1.0.0 (const: unstable) · Source§

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

Performs copy-assignment from source. Read more
Source§

impl Debug for PlPgSqlStmt

Source§

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

Formats the value using the given formatter. Read more
Source§

impl Display for PlPgSqlStmt

Source§

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

Formats the value using the given formatter. Read more
Source§

impl PartialEq for PlPgSqlStmt

Source§

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

Tests for self and other values to be equal, and is used by ==.
1.0.0 (const: unstable) · Source§

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

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.
Source§

impl StructuralPartialEq for PlPgSqlStmt

Auto Trait Implementations§

Blanket Implementations§

Source§

impl<T> Any for T
where T: 'static + ?Sized,

Source§

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more
Source§

impl<T> Borrow<T> for T
where T: ?Sized,

Source§

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more
Source§

impl<T> BorrowMut<T> for T
where T: ?Sized,

Source§

fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more
Source§

impl<T> CloneToUninit for T
where T: Clone,

Source§

unsafe fn clone_to_uninit(&self, dest: *mut u8)

🔬This is a nightly-only experimental API. (clone_to_uninit)
Performs copy-assignment from self to dest. Read more
Source§

impl<T> From<T> for T

Source§

fn from(t: T) -> T

Returns the argument unchanged.

Source§

impl<T, U> Into<U> for T
where U: From<T>,

Source§

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

Source§

impl<T> ToOwned for T
where T: Clone,

Source§

type Owned = T

The resulting type after obtaining ownership.
Source§

fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more
Source§

fn clone_into(&self, target: &mut T)

Uses borrowed data to replace owned data, usually by cloning. Read more
Source§

impl<T> ToString for T
where T: Display + ?Sized,

Source§

fn to_string(&self) -> String

Converts the given value to a String. Read more
Source§

impl<T, U> TryFrom<U> for T
where U: Into<T>,

Source§

type Error = Infallible

The type returned in the event of a conversion error.
Source§

fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>

Performs the conversion.
Source§

impl<T, U> TryInto<U> for T
where U: TryFrom<T>,

Source§

type Error = <U as TryFrom<T>>::Error

The type returned in the event of a conversion error.
Source§

fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

Performs the conversion.