Copyright | Flipstone Technology Partners 2023 |
---|---|
License | MIT |
Stability | Stable |
Safe Haskell | Safe-Inferred |
Language | Haskell2010 |
Since: 1.0.0.0
Synopsis
- data OrderByClause
- orderByClause :: OrderByExpr -> OrderByClause
- data OrderByExpr
- appendOrderByExpr :: OrderByExpr -> OrderByExpr -> OrderByExpr
- orderByColumnName :: ColumnName -> OrderByDirection -> OrderByExpr
- orderByColumnsExpr :: NonEmpty (ColumnName, OrderByDirection) -> OrderByExpr
- data OrderByDirection
- data NullsOrder
- ascendingOrder :: OrderByDirection
- descendingOrder :: OrderByDirection
- ascendingOrderWith :: NullsOrder -> OrderByDirection
- descendingOrderWith :: NullsOrder -> OrderByDirection
Documentation
data OrderByClause Source #
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 Source # | |
Defined in Orville.PostgreSQL.Expr.OrderBy toRawSql :: OrderByClause -> RawSql Source # |
data OrderByExpr Source #
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 Source # | Since: 1.0.0.0 |
Defined in Orville.PostgreSQL.Expr.OrderBy (<>) :: OrderByExpr -> OrderByExpr -> OrderByExpr # sconcat :: NonEmpty OrderByExpr -> OrderByExpr # stimes :: Integral b => b -> OrderByExpr -> OrderByExpr # | |
SqlExpression OrderByExpr Source # | Since: 1.0.0.0 |
Defined in Orville.PostgreSQL.Expr.OrderBy toRawSql :: OrderByExpr -> RawSql Source # unsafeFromRawSql :: RawSql -> OrderByExpr Source # |
appendOrderByExpr :: OrderByExpr -> OrderByExpr -> OrderByExpr Source #
Combines two OrderByExpr
s with a comma between them.
Since: 1.0.0.0
orderByColumnsExpr :: NonEmpty (ColumnName, OrderByDirection) -> OrderByExpr Source #
Create an OrderByExpr
for ColumnName
and OrderByDirection
pairs, ensuring commas as
needed.
Since: 1.0.0.0
data OrderByDirection Source #
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
data NullsOrder Source #
Type to represent the ordering of Null, intended to be used with OrderByDirection
.
Since: 1.0.0.0
Instances
ascendingOrder :: OrderByDirection Source #
The SQL ASC order direction.
Since: 1.0.0.0
descendingOrder :: OrderByDirection Source #
The SQL DESC order direction.
Since: 1.0.0.0
ascendingOrderWith :: NullsOrder -> OrderByDirection Source #
The SQL ASC order direction with NULLs ordered as given.
Since: 1.0.0.0
descendingOrderWith :: NullsOrder -> OrderByDirection Source #
The SQL DESC order direction with NULLs ordered as given.
Since: 1.0.0.0