Skip to main content

setval

Function setval 

Source
pub fn setval<'a, V, E, N>(
    sequence: E,
    value: N,
) -> SQLExpr<'a, V, <V::DialectMarker as DialectTypes>::BigInt, <E::Nullable as Nullability>::Or<N::Nullable>, <E::Aggregate as AggregateKind>::Or<N::Aggregate>, (E::Sources, N::Sources)>
Expand description

Sets a sequence’s current value (SETVAL), on PostgreSQL.

The next NEXTVAL returns value + 1. sequence must be text and value an integer. The result is the value set, as int8, nullable if either argument is.

§Examples

let reset = setval::<Value, _, _>("users_id_seq", 100);
assert_eq!(reset.sql(), "SETVAL ($1, $2)");