Orville.PostgreSQL.Expr.GroupBy

Since: 1.0.0.0

Documentation

data GroupByClause

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

GROUP BY team_name

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

Since: 1.0.0.0

Instances

SqlExpression GroupByClause

Since: 1.0.0.0

Defined in Orville.PostgreSQL.Expr.GroupBy

Methods

toRawSql :: GroupByClause -> RawSql

unsafeFromRawSql :: RawSql -> GroupByClause

groupByClause :: GroupByExpr -> GroupByClause

Create a full SQL GROUP BY clause with the given expression.

Since: 1.0.0.0

data GroupByExpr

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

team_name

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

Since: 1.0.0.0

Instances

Semigroup GroupByExpr

Since: 1.0.0.0

Defined in Orville.PostgreSQL.Expr.GroupBy

Methods

(<>) :: GroupByExpr -> GroupByExpr -> GroupByExpr

sconcat :: NonEmpty GroupByExpr -> GroupByExpr

stimes :: Integral b => b -> GroupByExpr -> GroupByExpr

SqlExpression GroupByExpr

Since: 1.0.0.0

Defined in Orville.PostgreSQL.Expr.GroupBy

Methods

toRawSql :: GroupByExpr -> RawSql

unsafeFromRawSql :: RawSql -> GroupByExpr

appendGroupByExpr :: GroupByExpr -> GroupByExpr -> GroupByExpr

Combines two GroupByExprs with a comma between them.

Since: 1.0.0.0

groupByColumnsExpr :: NonEmpty ColumnName -> GroupByExpr

Create a GroupByExpr from the given ColumnNames.

Since: 1.0.0.0