Struct ValuesQuery 

pub struct ValuesQuery {
    pub with: With,
    pub values: Values,
    pub order_by: OrderBy,
    pub limit: Limit,
    pub offset: Offset,
    pub fetch: Fetch,
    pub combines: Combines,
}

A standalone PostgreSQL VALUES statement.

From https://www.postgresql.org/docs/17/sql-values.html:

VALUES ( expression [, ...] ) [, ...]
    [ ORDER BY sort_expression [ ASC | DESC | USING operator ] [, ...] ]
    [ LIMIT { count | ALL } ]
    [ OFFSET start [ ROW | ROWS ] ]
    [ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } { ONLY | WITH TIES } ]

VALUES is a simple_select alternative in gram.y, so it also takes a leading WITH and participates in set operations — VALUES (1) UNION SELECT … — and the tail clauses of a combination live in Combines, as they do for a SELECT. The columns of the result are named column1, column2, …, which is what an ORDER BY here refers to (or ORDER BY 1).

It has no FOR UPDATE: PostgreSQL rejects a locking clause on VALUES, so HasLocks is not implemented and values::for_update does not exist.

The rows are the same Values clause an INSERT holds, minus its query alternative: a standalone VALUES is rows, so a Values::query set here is a recorded build error rather than something to render around.

Fields

with: With

WITH ….

values: Values

The rows.

order_by: OrderBy

ORDER BY … — this statement’s own.

limit: Limit

LIMIT … — this statement’s own.

offset: Offset

OFFSET … — this statement’s own.

fetch: Fetch

FETCH … — this statement’s own.

combines: Combines

The set operations, and the trailing clauses that belong to their result.

Implementations

impl ValuesQuery

pub fn new() -> ValuesQuery

A VALUES with no rows yet — which does not build until it has one.

pub fn apply(&mut self, mods: impl Mod<ValuesQuery>)

Apply more mods to an existing query.

Trait Implementations

impl Clone for ValuesQuery

fn clone(&self) -> ValuesQuery

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for ValuesQuery

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

Formats the value using the given formatter.

impl Default for ValuesQuery

fn default() -> ValuesQuery

Returns the “default value” for a type.

impl Expression for ValuesQuery

fn write_sql(&self, w: &mut SqlWriter<'_>)

Append this fragment to w.

impl HasCombines for ValuesQuery

fn combines_mut(&mut self) -> &mut Combines

The set operations to modify.

impl HasFetch for ValuesQuery

fn fetch_mut(&mut self) -> &mut Fetch

The FETCH clause to modify.

impl HasLimit for ValuesQuery

fn limit_mut(&mut self) -> &mut Limit

The LIMIT clause to modify.

impl HasOffset for ValuesQuery

fn offset_mut(&mut self) -> &mut Offset

The OFFSET clause to modify.

impl HasOrderBy for ValuesQuery

fn order_by_mut(&mut self) -> &mut OrderBy

The ORDER BY clause to modify.

impl HasValues for ValuesQuery

fn values_mut(&mut self) -> &mut Values

The row source to modify.

impl HasWith for ValuesQuery

fn with_mut(&mut self) -> &mut With

The WITH clause to modify.

impl IntoExpr for ValuesQuery

fn into_expr(self) -> Expr

Perform the conversion.

impl IntoExprList for ValuesQuery

fn into_expr_list(self) -> Vec<Expr>

Perform the conversion.

impl Query for ValuesQuery

fn query_type(&self) -> QueryType

Which statement this renders.

fn dialect(&self) -> &dyn Dialect

The dialect this query renders itself in.

fn build(&self) -> Result<(String, Vec<Value>), Error>

Render to SQL and arguments, numbering placeholders from 1.

fn build_from(&self, start: usize) -> Result<(String, Vec<Value>), Error>

build with a different first placeholder position, for splicing into a statement that already has arguments — bob’s BuildN.

impl<H, L, M> QueryExtensions<H, L, M> for ValuesQuery

fn hooks(&self) -> &[Hook]

Hooks to run before this query executes.

fn loaders(&self) -> &[Loader]

Loaders to run after this query executes, for eagerly loaded relations.

fn mapper_mods(&self) -> &[MapperMod]

Adjustments to the row mapper, for relations loaded in the same query.