pub struct Query {
pub with: Option<With>,
pub body: Box<SetExpr>,
pub order_by: Vec<OrderByExpr>,
pub limit: Option<Expr>,
pub offset: Option<Offset>,
pub fetch: Option<Fetch>,
pub locks: Vec<LockClause>,
}
Expand description
The most complete variant of a SELECT
query expression, optionally
including WITH
, UNION
/ other set operations, and ORDER BY
.
Fields§
§with: Option<With>
WITH (common table expressions, or CTEs)
body: Box<SetExpr>
SELECT or UNION / EXCEPT / INTERSECT
order_by: Vec<OrderByExpr>
ORDER BY
limit: Option<Expr>
LIMIT { <N> | ALL }
offset: Option<Offset>
OFFSET <N> [ { ROW | ROWS } ]
fetch: Option<Fetch>
FETCH { FIRST | NEXT } <N> [ PERCENT ] { ROW | ROWS } | { ONLY | WITH TIES }
locks: Vec<LockClause>
FOR { UPDATE | SHARE } [ OF table_name ] [ SKIP LOCKED | NOWAIT ]
Trait Implementations§
source§impl<'de> Deserialize<'de> for Query
impl<'de> Deserialize<'de> for Query
source§fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>where
__D: Deserializer<'de>,
fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>where __D: Deserializer<'de>,
Deserialize this value from the given Serde deserializer. Read more
source§impl Ord for Query
impl Ord for Query
source§impl PartialEq<Query> for Query
impl PartialEq<Query> for Query
source§impl PartialOrd<Query> for Query
impl PartialOrd<Query> for Query
1.0.0 · source§fn le(&self, other: &Rhs) -> bool
fn le(&self, other: &Rhs) -> bool
This method tests less than or equal to (for
self
and other
) and is used by the <=
operator. Read more