beam-core-0.10.1.0: Type-safe, feature-complete SQL query and manipulation interface for Haskell
Safe HaskellSafe-Inferred
LanguageHaskell2010

Database.Beam.Backend.SQL.SQL2003

Description

Modular finally tagless extension of SQL99 and SQL92 syntaxes for various SQL2003 core and optional features.

Synopsis

Documentation

class IsSql92OrderingSyntax ord => IsSql2003OrderingElementaryOLAPOperationsSyntax ord where Source #

Optional SQL2003 "Elementary OLAP operations" T611 support

Methods

nullsFirstOrdering :: ord -> ord Source #

nullsLastOrdering :: ord -> ord Source #

class IsSql2003ExpressionSyntax expr => IsSql2003ExpressionElementaryOLAPOperationsSyntax expr where Source #

Optional SQL2003 "Elementary OLAP operations" T611 support

Methods

filterAggE :: expr -> expr -> expr Source #

rankAggE :: expr Source #

class IsSql99DataTypeSyntax dataType => IsSql2003BinaryAndVarBinaryDataTypeSyntax dataType where Source #

Optional SQL2003 "BINARY AND VARBINARY data type" T021 support

Methods

binaryType :: Maybe Word -> dataType Source #

varBinaryType :: Maybe Word -> dataType Source #

class IsSql2003WindowFrameBoundsSyntax (Sql2003WindowFrameBoundsSyntax frame) => IsSql2003WindowFrameSyntax frame where Source #

class IsSql99ExpressionSyntax expr => IsSql2003EnhancedNumericFunctionsExpressionSyntax expr where Source #

Optional SQL2003 "Enhanced numeric functions" T621 support

Methods

lnE :: expr -> expr Source #

expE :: expr -> expr Source #

sqrtE :: expr -> expr Source #

ceilE :: expr -> expr Source #

floorE :: expr -> expr Source #

powerE :: expr -> expr -> expr Source #

class IsSql99AggregationExpressionSyntax agg => IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax agg where Source #

Instances

Instances details
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax Expression Source # 
Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

stddevPopE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

stddevSampE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

varPopE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

varSampE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

covarPopE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

covarSampE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

corrE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrSlopeE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrInterceptE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrCountE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrRSquaredE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrAvgXE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrAvgYE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrSXXE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrSXYE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrSYYE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

class IsSql99AggregationExpressionSyntax agg => IsSql2003FirstValueAndLastValueExpressionSyntax agg where Source #

Optional SQL2003 "FIRST_VALUE and LAST_VALUE function" T616 support

Methods

firstValueE :: agg -> agg Source #

lastValueE :: agg -> agg Source #

class IsSql99AggregationExpressionSyntax agg => IsSql2003NtileExpressionSyntax agg where Source #

Optional SQL2003 "NTILE function" T614 support

Methods

ntileE :: agg -> agg Source #

Instances

Instances details
IsSql2003NtileExpressionSyntax Expression Source # 
Instance details

Defined in Database.Beam.Backend.SQL.AST

class IsSql99AggregationExpressionSyntax agg => IsSql2003NthValueExpressionSyntax agg where Source #

Optional SQL2003 "NTH_VALUE function" T618 support

Methods

nthValueE :: agg -> agg -> agg Source #

class IsSql99AggregationExpressionSyntax agg => IsSql2003LeadAndLagExpressionSyntax agg where Source #

Optional SQL2003 "LEAD and LAG function" T615 support

Methods

leadE :: agg -> Maybe agg -> Maybe agg -> agg Source #

lagE :: agg -> Maybe agg -> Maybe agg -> agg Source #

class IsSql99DataTypeSyntax dataType => IsSql2008BigIntDataTypeSyntax dataType where Source #

Optional SQL2008 "BIGINT data type" T071 support

Methods

bigIntType :: dataType Source #

Instances

Instances details
IsSql2008BigIntDataTypeSyntax DataType Source # 
Instance details

Defined in Database.Beam.Backend.SQL.AST