Orville.PostgreSQL.Expr.OrderBy

Since: 1.0.0.0

Documentation

data OrderByClause

Type to represent a SQL order by clause. E.G.

ORDER BY foo, bar

OrderByClause provides a SqlExpression instance. See unsafeSqlExpression for how to construct a value with your own custom SQL.

Since: 1.0.0.0

Instances

SqlExpression OrderByClause

Defined in Orville.PostgreSQL.Expr.OrderBy

Methods

toRawSql :: OrderByClause -> RawSql

unsafeFromRawSql :: RawSql -> OrderByClause

orderByClause :: OrderByExpr -> OrderByClause

data OrderByExpr

Type to represent a SQL order by expression (the part that follows the ORDER BY in SQL). E.G.

foo, bar

OrderByExpr provides a SqlExpression instance. See unsafeSqlExpression for how to construct a value with your own custom SQL.

Since: 1.0.0.0

Instances

Semigroup OrderByExpr

Since: 1.0.0.0

Defined in Orville.PostgreSQL.Expr.OrderBy

Methods

(<>) :: OrderByExpr -> OrderByExpr -> OrderByExpr

sconcat :: NonEmpty OrderByExpr -> OrderByExpr

stimes :: Integral b => b -> OrderByExpr -> OrderByExpr

SqlExpression OrderByExpr

Since: 1.0.0.0

Defined in Orville.PostgreSQL.Expr.OrderBy

Methods

toRawSql :: OrderByExpr -> RawSql

unsafeFromRawSql :: RawSql -> OrderByExpr

appendOrderByExpr :: OrderByExpr -> OrderByExpr -> OrderByExpr

Combines two OrderByExprs with a comma between them.

Since: 1.0.0.0

orderByColumnName :: ColumnName -> OrderByDirection -> OrderByExpr

orderByColumnsExpr :: NonEmpty (ColumnName, OrderByDirection) -> OrderByExpr

Create an OrderByExpr for ColumnName and OrderByDirection pairs, ensuring commas as needed.

Since: 1.0.0.0

data OrderByDirection

Type to represent a SQL order by direction expression. E.G.

ASC

OrderByDirection provides a SqlExpression instance. See unsafeSqlExpression for how to construct a value with your own custom SQL.

Since: 1.0.0.0

Instances

SqlExpression OrderByDirection

Defined in Orville.PostgreSQL.Expr.OrderBy

Methods

toRawSql :: OrderByDirection -> RawSql

unsafeFromRawSql :: RawSql -> OrderByDirection

data NullsOrder

Type to represent the ordering of Null, intended to be used with OrderByDirection.

Since: 1.0.0.0

Constructors

NullsFirst

NullsLast

Instances

Bounded NullsOrder

Since: 1.0.0.0

Defined in Orville.PostgreSQL.Expr.OrderBy

Methods

minBound :: NullsOrder

maxBound :: NullsOrder

Enum NullsOrder

Since: 1.0.0.0

Defined in Orville.PostgreSQL.Expr.OrderBy

Methods

succ :: NullsOrder -> NullsOrder

pred :: NullsOrder -> NullsOrder

toEnum :: Int -> NullsOrder

fromEnum :: NullsOrder -> Int

enumFrom :: NullsOrder -> [NullsOrder]

enumFromThen :: NullsOrder -> NullsOrder -> [NullsOrder]

enumFromTo :: NullsOrder -> NullsOrder -> [NullsOrder]

enumFromThenTo :: NullsOrder -> NullsOrder -> NullsOrder -> [NullsOrder]

Show NullsOrder

Since: 1.0.0.0

Defined in Orville.PostgreSQL.Expr.OrderBy

Methods

showsPrec :: Int -> NullsOrder -> ShowS

show :: NullsOrder -> String

showList :: [NullsOrder] -> ShowS

Eq NullsOrder

Since: 1.0.0.0

Defined in Orville.PostgreSQL.Expr.OrderBy

Methods

(==) :: NullsOrder -> NullsOrder -> Bool

(/=) :: NullsOrder -> NullsOrder -> Bool

Ord NullsOrder

Since: 1.0.0.0

Defined in Orville.PostgreSQL.Expr.OrderBy

Methods

compare :: NullsOrder -> NullsOrder -> Ordering

(<) :: NullsOrder -> NullsOrder -> Bool

(<=) :: NullsOrder -> NullsOrder -> Bool

(>) :: NullsOrder -> NullsOrder -> Bool

(>=) :: NullsOrder -> NullsOrder -> Bool

max :: NullsOrder -> NullsOrder -> NullsOrder

min :: NullsOrder -> NullsOrder -> NullsOrder

ascendingOrder :: OrderByDirection

The SQL ASC order direction.

Since: 1.0.0.0

descendingOrder :: OrderByDirection

The SQL DESC order direction.

Since: 1.0.0.0

ascendingOrderWith :: NullsOrder -> OrderByDirection

The SQL ASC order direction with NULLs ordered as given.

Since: 1.0.0.0

descendingOrderWith :: NullsOrder -> OrderByDirection

The SQL DESC order direction with NULLs ordered as given.

Since: 1.0.0.0