Struct SelectQuery 

pub struct SelectQuery<T: Table, O = ()> { /* private fields */ }

Implementations

impl<T: Table, O> SelectQuery<T, O>

pub fn select<S: Selection>(self, selection: S) -> SelectQuery<T, S::Output>

pub fn select_all(self) -> SelectQuery<T, ()>

Select every column for driver-owned row access.

The output is intentionally untyped because a table marker does not define a Rust record decoder. Use an explicit selection with fetch_all_as when typed decoding is required.

pub fn distinct(self) -> Self

pub fn with<C: Table>(self, cte: Cte<C>) -> Self

pub fn as_cte<C: Table>(self) -> Cte<C>

pub fn filter(self, expression: Expression) -> Self

pub fn group_by<TableType, ValueType>( self, column: Column<TableType, ValueType>, ) -> Self

pub fn having(self, expression: Expression) -> Self

pub fn inner_join<J: Table>(self, on: Expression) -> Self

pub fn left_join<J: Table>(self, on: Expression) -> Self

pub fn right_join<J: Table>(self, on: Expression) -> Self

pub fn full_join<J: Table>(self, on: Expression) -> Self

pub fn inner_join_as<Source: Table, Alias: Table>(self, on: Expression) -> Self

pub fn left_join_as<Source: Table, Alias: Table>(self, on: Expression) -> Self

pub fn order_by<TableType, ValueType>( self, column: Column<TableType, ValueType>, direction: OrderDirection, ) -> Self

pub fn order_by_expression<ValueType>( self, expression: TypedExpression<ValueType>, direction: OrderDirection, ) -> Self

pub fn limit(self, limit: u64) -> Self

pub fn offset(self, offset: u64) -> Self

pub fn for_update(self) -> Self

Lock every selected row with PostgreSQL FOR UPDATE.

pub fn for_update_of<Locked: Table>(self) -> Self

Lock only the named source or join marker with PostgreSQL FOR UPDATE OF.

pub fn for_no_key_update(self) -> Self

Lock every selected row with PostgreSQL FOR NO KEY UPDATE.

pub fn for_no_key_update_of<Locked: Table>(self) -> Self

Lock only the named source or join marker with PostgreSQL FOR NO KEY UPDATE OF.

pub fn for_share(self) -> Self

Lock every selected row with PostgreSQL FOR SHARE.

pub fn for_share_of<Locked: Table>(self) -> Self

Lock only the named source or join marker with PostgreSQL FOR SHARE OF.

pub fn for_key_share(self) -> Self

Lock every selected row with PostgreSQL FOR KEY SHARE.

pub fn for_key_share_of<Locked: Table>(self) -> Self

Lock only the named source or join marker with PostgreSQL FOR KEY SHARE OF.

pub fn no_wait(self) -> Self

Fail instead of waiting for a conflicting row lock.

pub fn skip_locked(self) -> Self

Skip rows currently held by a conflicting row lock.

pub fn union<Source: Table>(self, query: SelectQuery<Source, O>) -> Self

pub fn union_all<Source: Table>(self, query: SelectQuery<Source, O>) -> Self

pub fn intersect<Source: Table>(self, query: SelectQuery<Source, O>) -> Self

pub fn except<Source: Table>(self, query: SelectQuery<Source, O>) -> Self

Trait Implementations

impl<T: Clone + Table, O: Clone> Clone for SelectQuery<T, O>

fn clone(&self) -> SelectQuery<T, O>

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl<T: Debug + Table, O: Debug> Debug for SelectQuery<T, O>

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

Formats the value using the given formatter.

impl<T: Table, O> Query for SelectQuery<T, O>

type Output = O

fn compile(self, dialect: &impl Dialect) -> Result<CompiledQuery>