Type Alias SelectBuilder 

pub type SelectBuilder<'a, Schema, State, Table = ()> = QueryBuilder<'a, Schema, State, Table>;

Builds a SELECT query specifically for PostgreSQL

Aliased Type

pub struct SelectBuilder<'a, Schema, State, Table = ()> {
    pub sql: SQL<'a, PostgresValue<'a>>,
    /* private fields */
}

Fields

sql: SQL<'a, PostgresValue<'a>>

Implementations

impl<'a, S> SelectBuilder<'a, S, SelectInitial>

pub fn from<T>(self, query: T) -> SelectBuilder<'a, S, SelectFromSet, T>

where T: ToPostgresSQL<'a>,

Specifies the table to select FROM and transitions state

impl<'a, S, T> SelectBuilder<'a, S, SelectFromSet, T>

where T: SQLTable<'a, PostgresSchemaType, PostgresValue<'a>>,

pub fn join<U: PostgresTable<'a>>( self, table: U, condition: SQL<'a, PostgresValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

Adds a JOIN clause to the query

pub fn natural_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn natural_left_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn left_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn left_outer_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn natural_left_outer_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn natural_right_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn right_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn right_outer_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn natural_right_outer_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn natural_full_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn full_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn full_outer_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn natural_full_outer_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn inner_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn cross_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn left_join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

pub fn left_outer_join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

pub fn right_join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

pub fn right_outer_join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

pub fn full_join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

pub fn full_outer_join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

pub fn inner_join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

pub fn join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

pub fn where( self, condition: SQL<'a, PostgresValue<'a>>, ) -> SelectBuilder<'a, S, SelectWhereSet, T>

pub fn group_by( self, expressions: Vec<SQL<'a, PostgresValue<'a>>>, ) -> SelectBuilder<'a, S, SelectGroupSet, T>

Adds a GROUP BY clause to the query

pub fn limit(self, limit: usize) -> SelectBuilder<'a, S, SelectLimitSet, T>

Limits the number of rows returned

pub fn offset(self, offset: usize) -> SelectBuilder<'a, S, SelectOffsetSet, T>

Sets the offset for the query results

pub fn order_by<TOrderBy>( self, expressions: TOrderBy, ) -> SelectBuilder<'a, S, SelectOrderSet, T>

where TOrderBy: ToPostgresSQL<'a>,

Sorts the query results

impl<'a, S, T> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn where( self, condition: SQL<'a, PostgresValue<'a>>, ) -> SelectBuilder<'a, S, SelectWhereSet, T>

Adds a WHERE condition after a JOIN

pub fn order_by<TOrderBy>( self, expressions: TOrderBy, ) -> SelectBuilder<'a, S, SelectOrderSet, T>

where TOrderBy: ToPostgresSQL<'a>,

Sorts the query results

pub fn join<U: PostgresTable<'a>>( self, table: U, condition: SQL<'a, PostgresValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

Adds a JOIN clause to the query

pub fn natural_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn natural_left_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn left_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn left_outer_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn natural_left_outer_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn natural_right_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn right_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn right_outer_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn natural_right_outer_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn natural_full_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn full_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn full_outer_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn natural_full_outer_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn inner_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn cross_join<U: PostgresTable<'a>>( self, table: U, condition: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with ON clause

pub fn left_join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

pub fn left_outer_join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

pub fn right_join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

pub fn right_outer_join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

pub fn full_join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

pub fn full_outer_join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

pub fn inner_join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

pub fn join_using<U: PostgresTable<'a>>( self, table: U, columns: impl ToPostgresSQL<'a>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

JOIN with USING clause (PostgreSQL-specific)

impl<'a, S, T> SelectBuilder<'a, S, SelectWhereSet, T>

pub fn group_by( self, expressions: Vec<SQL<'a, PostgresValue<'a>>>, ) -> SelectBuilder<'a, S, SelectGroupSet, T>

Adds a GROUP BY clause after a WHERE

pub fn order_by<TOrderBy>( self, expressions: TOrderBy, ) -> SelectBuilder<'a, S, SelectOrderSet, T>

where TOrderBy: ToPostgresSQL<'a>,

Adds an ORDER BY clause after a WHERE

pub fn limit(self, limit: usize) -> SelectBuilder<'a, S, SelectLimitSet, T>

Adds a LIMIT clause after a WHERE

impl<'a, S, T> SelectBuilder<'a, S, SelectGroupSet, T>

pub fn having( self, condition: SQL<'a, PostgresValue<'a>>, ) -> SelectBuilder<'a, S, SelectGroupSet, T>

Adds a HAVING clause after GROUP BY

pub fn order_by<TOrderBy>( self, expressions: TOrderBy, ) -> SelectBuilder<'a, S, SelectOrderSet, T>

where TOrderBy: ToPostgresSQL<'a>,

Adds an ORDER BY clause after GROUP BY

impl<'a, S, T> SelectBuilder<'a, S, SelectOrderSet, T>

pub fn limit(self, limit: usize) -> SelectBuilder<'a, S, SelectLimitSet, T>

Adds a LIMIT clause after ORDER BY

impl<'a, S, T> SelectBuilder<'a, S, SelectLimitSet, T>

pub fn offset(self, offset: usize) -> SelectBuilder<'a, S, SelectOffsetSet, T>

Adds an OFFSET clause after LIMIT