Struct Fetch 

pub struct Fetch {
    pub count: Option<Expr>,
    pub first_or_next: FirstOrNext,
    pub rows: RowsKeyword,
    pub with_ties: bool,
}

FETCH { FIRST | NEXT } n { ROW | ROWS } { ONLY | WITH TIES } — the SQL-standard spelling of LIMIT, and the only one that can ask for ties.

From PostgreSQL 17:

[ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } { ONLY | WITH TIES } ]

FIRST/NEXT and ROW/ROWS are pure synonyms in the grammar, but not on the page: which one a query says is visible whenever generated SQL is read or diffed against a hand-written statement, so every spelling is representable. The defaults write FETCH NEXT n ROWS. WITH TIES requires an ORDER BY, which is the statement’s business rather than this clause’s.

Fields

count: Option<Expr>

How many rows.

first_or_next: FirstOrNext

FETCH FIRST rather than FETCH NEXT.

rows: RowsKeyword

ROW or ROWS, either legal whatever the count.

with_ties: bool

WITH TIES rather than ONLY: also return rows that tie with the last one under the ORDER BY.

Implementations

impl Fetch

pub fn new(count: impl IntoExpr) -> Self

Fetch count rows, without ties, in the default spelling.

pub fn set_fetch(&mut self, count: impl IntoExpr)

Set the count.

pub fn is_empty(&self) -> bool

Whether the clause is absent.

Trait Implementations

impl Clone for Fetch

fn clone(&self) -> Fetch

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Fetch

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

Formats the value using the given formatter.

impl Default for Fetch

fn default() -> Fetch

Returns the “default value” for a type.

impl Expression for Fetch

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

Append this fragment to w.

impl HasFetch for Fetch

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

The FETCH clause to modify.