Safe Haskell	None
Language	Haskell2010

Database.Beam.Postgres.Syntax

Description

Data types for Postgres syntax. Access is given mainly for extension modules. The types and definitions here are likely to change.

Synopsis

data PgSyntaxF f where
- EmitByteString :: ByteString -> f -> PgSyntaxF f
- EmitBuilder :: Builder -> f -> PgSyntaxF f
- EscapeString :: ByteString -> f -> PgSyntaxF f
- EscapeBytea :: ByteString -> f -> PgSyntaxF f
- EscapeIdentifier :: ByteString -> f -> PgSyntaxF f
type PgSyntaxM = F PgSyntaxF
newtype PgSyntax = PgSyntax {
- buildPgSyntax :: PgSyntaxM ()
}
emit :: ByteString -> PgSyntax
emitBuilder :: Builder -> PgSyntax
escapeString :: ByteString -> PgSyntax
escapeBytea :: ByteString -> PgSyntax
escapeIdentifier :: ByteString -> PgSyntax
pgParens :: PgSyntax -> PgSyntax
nextSyntaxStep :: PgSyntaxF f -> f
data PgCommandSyntax = PgCommandSyntax {
- pgCommandType :: PgCommandType
- fromPgCommand :: PgSyntax
}
data PgCommandType
- = PgCommandTypeQuery
- | PgCommandTypeDdl
- | PgCommandTypeDataUpdate
- | PgCommandTypeDataUpdateReturning
newtype PgSelectSyntax = PgSelectSyntax {
- fromPgSelect :: PgSyntax
}
newtype PgSelectSetQuantifierSyntax = PgSelectSetQuantifierSyntax {
- fromPgSelectSetQuantifier :: PgSyntax
}
newtype PgInsertSyntax = PgInsertSyntax {
- fromPgInsert :: PgSyntax
}
newtype PgDeleteSyntax = PgDeleteSyntax {
- fromPgDelete :: PgSyntax
}
newtype PgUpdateSyntax = PgUpdateSyntax {
- fromPgUpdate :: PgSyntax
}
newtype PgExpressionSyntax = PgExpressionSyntax {
- fromPgExpression :: PgSyntax
}
newtype PgFromSyntax = PgFromSyntax {
- fromPgFrom :: PgSyntax
}
newtype PgTableNameSyntax = PgTableNameSyntax {
- fromPgTableName :: PgSyntax
}
newtype PgComparisonQuantifierSyntax = PgComparisonQuantifierSyntax {
- fromPgComparisonQuantifier :: PgSyntax
}
newtype PgExtractFieldSyntax = PgExtractFieldSyntax {
- fromPgExtractField :: PgSyntax
}
newtype PgProjectionSyntax = PgProjectionSyntax {
- fromPgProjection :: PgSyntax
}
newtype PgGroupingSyntax = PgGroupingSyntax {
- fromPgGrouping :: PgSyntax
}
data PgOrderingSyntax = PgOrderingSyntax {
- pgOrderingSyntax :: PgSyntax
- pgOrderingNullOrdering :: Maybe PgNullOrdering
}
newtype PgValueSyntax = PgValueSyntax {
- fromPgValue :: PgSyntax
}
newtype PgTableSourceSyntax = PgTableSourceSyntax {
- fromPgTableSource :: PgSyntax
}
newtype PgFieldNameSyntax = PgFieldNameSyntax {
- fromPgFieldName :: PgSyntax
}
newtype PgAggregationSetQuantifierSyntax = PgAggregationSetQuantifierSyntax {
- fromPgAggregationSetQuantifier :: PgSyntax
}
newtype PgInsertValuesSyntax = PgInsertValuesSyntax {
- fromPgInsertValues :: PgSyntax
}
newtype PgInsertOnConflictSyntax = PgInsertOnConflictSyntax {
- fromPgInsertOnConflict :: PgSyntax
}
newtype PgInsertOnConflictTargetSyntax = PgInsertOnConflictTargetSyntax {
- fromPgInsertOnConflictTarget :: PgSyntax
}
newtype PgConflictActionSyntax = PgConflictActionSyntax {
- fromPgConflictAction :: PgSyntax
}
newtype PgCreateTableSyntax = PgCreateTableSyntax {
- fromPgCreateTable :: PgSyntax
}
data PgTableOptionsSyntax = PgTableOptionsSyntax PgSyntax PgSyntax
newtype PgColumnSchemaSyntax = PgColumnSchemaSyntax {
- fromPgColumnSchema :: PgSyntax
}
data PgDataTypeSyntax = PgDataTypeSyntax {
- pgDataTypeDescr :: PgDataTypeDescr
- fromPgDataType :: PgSyntax
- pgDataTypeSerialized :: BeamSerializedDataType
}
data PgColumnConstraintDefinitionSyntax = PgColumnConstraintDefinitionSyntax {
- fromPgColumnConstraintDefinition :: PgSyntax
- pgColumnConstraintDefinitionSerialized :: BeamSerializedConstraintDefinition
}
data PgColumnConstraintSyntax = PgColumnConstraintSyntax {
- fromPgColumnConstraint :: PgSyntax
- pgColumnConstraintSerialized :: BeamSerializedConstraint
}
newtype PgTableConstraintSyntax = PgTableConstraintSyntax {
- fromPgTableConstraint :: PgSyntax
}
data PgMatchTypeSyntax = PgMatchTypeSyntax {
- fromPgMatchType :: PgSyntax
- pgMatchTypeSerialized :: BeamSerializedMatchType
}
data PgReferentialActionSyntax = PgReferentialActionSyntax {
- fromPgReferentialAction :: PgSyntax
- pgReferentialActionSerialized :: BeamSerializedReferentialAction
}
newtype PgAlterTableSyntax = PgAlterTableSyntax {
- fromPgAlterTable :: PgSyntax
}
newtype PgAlterTableActionSyntax = PgAlterTableActionSyntax {
- fromPgAlterTableAction :: PgSyntax
}
newtype PgAlterColumnActionSyntax = PgAlterColumnActionSyntax {
- fromPgAlterColumnAction :: PgSyntax
}
newtype PgWindowFrameSyntax = PgWindowFrameSyntax {
- fromPgWindowFrame :: PgSyntax
}
newtype PgWindowFrameBoundsSyntax = PgWindowFrameBoundsSyntax {
- fromPgWindowFrameBounds :: PgSyntax
}
newtype PgWindowFrameBoundSyntax = PgWindowFrameBoundSyntax {
- fromPgWindowFrameBound :: ByteString -> PgSyntax
}
data PgSelectLockingClauseSyntax = PgSelectLockingClauseSyntax {
- pgSelectLockingClauseStrength :: PgSelectLockingStrength
- pgSelectLockingTables :: [Text]
- pgSelectLockingClauseOptions :: Maybe PgSelectLockingOptions
}
data PgSelectLockingStrength
- = PgSelectLockingStrengthUpdate
- | PgSelectLockingStrengthNoKeyUpdate
- | PgSelectLockingStrengthShare
- | PgSelectLockingStrengthKeyShare
data PgSelectLockingOptions
- = PgSelectLockingOptionsNoWait
- | PgSelectLockingOptionsSkipLocked
fromPgSelectLockingClause :: PgSelectLockingClauseSyntax -> PgSyntax
pgSelectStmt :: PgSelectTableSyntax -> [PgOrderingSyntax] -> Maybe Integer -> Maybe Integer -> Maybe PgSelectLockingClauseSyntax -> PgSelectSyntax
defaultPgValueSyntax :: ToField a => a -> PgValueSyntax
data PgDataTypeDescr
- = PgDataTypeDescrOid Oid (Maybe Int32)
- | PgDataTypeDescrDomain Text
data PgHasEnum = PgHasEnum Text [Text]
pgCreateExtensionSyntax :: Text -> PgCommandSyntax
pgDropExtensionSyntax :: Text -> PgCommandSyntax
pgCreateEnumSyntax :: Text -> [PgValueSyntax] -> PgCommandSyntax
pgDropTypeSyntax :: Text -> PgCommandSyntax
pgSimpleMatchSyntax :: PgMatchTypeSyntax
pgSelectSetQuantifierDistinctOn :: [PgExpressionSyntax] -> PgSelectSetQuantifierSyntax
pgDataTypeJSON :: Value -> BeamSerializedDataType
pgTsQueryType :: PgDataTypeSyntax
pgTsVectorType :: PgDataTypeSyntax
pgJsonType :: PgDataTypeSyntax
pgJsonbType :: PgDataTypeSyntax
pgUuidType :: PgDataTypeSyntax
pgMoneyType :: PgDataTypeSyntax
pgTsQueryTypeInfo :: TypeInfo
pgTsVectorTypeInfo :: TypeInfo
pgByteaType :: PgDataTypeSyntax
pgTextType :: PgDataTypeSyntax
pgUnboundedArrayType :: PgDataTypeSyntax -> PgDataTypeSyntax
pgSerialType :: PgDataTypeSyntax
pgSmallSerialType :: PgDataTypeSyntax
pgBigSerialType :: PgDataTypeSyntax
pgPointType :: PgDataTypeSyntax
pgLineType :: PgDataTypeSyntax
pgLineSegmentType :: PgDataTypeSyntax
pgBoxType :: PgDataTypeSyntax
pgQuotedIdentifier :: Text -> PgSyntax
pgSepBy :: PgSyntax -> [PgSyntax] -> PgSyntax
pgDebugRenderSyntax :: PgSyntax -> IO ()
pgRenderSyntaxScript :: PgSyntax -> ByteString
pgBuildAction :: [Action] -> PgSyntax
pgBinOp :: ByteString -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax
pgCompOp :: ByteString -> Maybe PgComparisonQuantifierSyntax -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax
pgUnOp :: ByteString -> PgExpressionSyntax -> PgExpressionSyntax
pgPostFix :: ByteString -> PgExpressionSyntax -> PgExpressionSyntax
pgTestSyntax :: PgSyntax -> [PgSyntaxPrim]
data PostgresInaccessible

Documentation

data PgSyntaxF f where Source #

Constructors

EmitByteString :: ByteString -> f -> PgSyntaxF f
EmitBuilder :: Builder -> f -> PgSyntaxF f
EscapeString :: ByteString -> f -> PgSyntaxF f
EscapeBytea :: ByteString -> f -> PgSyntaxF f
EscapeIdentifier :: ByteString -> f -> PgSyntaxF f

Instances

Functor PgSyntaxF Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods fmap :: (a -> b) -> PgSyntaxF a -> PgSyntaxF b # (<$) :: a -> PgSyntaxF b -> PgSyntaxF a #
Eq1 PgSyntaxF Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods liftEq :: (a -> b -> Bool) -> PgSyntaxF a -> PgSyntaxF b -> Bool #
Eq f => Eq (PgSyntaxF f) Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods (==) :: PgSyntaxF f -> PgSyntaxF f -> Bool # (/=) :: PgSyntaxF f -> PgSyntaxF f -> Bool #

type PgSyntaxM = F PgSyntaxF Source #

newtype PgSyntax Source #

A piece of Postgres SQL syntax, which may contain embedded escaped byte and text sequences. PgSyntax composes monoidally, and may be created with emit, emitBuilder, escapeString, escapBytea, and escapeIdentifier.

Constructors

PgSyntax
Fields buildPgSyntax :: PgSyntaxM ()

Instances

Eq PgSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods (==) :: PgSyntax -> PgSyntax -> Bool # (/=) :: PgSyntax -> PgSyntax -> Bool #
Show PgSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods showsPrec :: Int -> PgSyntax -> ShowS # show :: PgSyntax -> String # showList :: [PgSyntax] -> ShowS #
Semigroup PgSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods (<>) :: PgSyntax -> PgSyntax -> PgSyntax # sconcat :: NonEmpty PgSyntax -> PgSyntax # stimes :: Integral b => b -> PgSyntax -> PgSyntax #
Monoid PgSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods mempty :: PgSyntax # mappend :: PgSyntax -> PgSyntax -> PgSyntax # mconcat :: [PgSyntax] -> PgSyntax #
Hashable PgSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods hashWithSalt :: Int -> PgSyntax -> Int # hash :: PgSyntax -> Int #
Sql92DisplaySyntax PgSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods displaySyntax :: PgSyntax -> String #

emit :: ByteString -> PgSyntax Source #

emitBuilder :: Builder -> PgSyntax Source #

escapeString :: ByteString -> PgSyntax Source #

escapeBytea :: ByteString -> PgSyntax Source #

escapeIdentifier :: ByteString -> PgSyntax Source #

pgParens :: PgSyntax -> PgSyntax Source #

nextSyntaxStep :: PgSyntaxF f -> f Source #

data PgCommandSyntax Source #

Representation of an arbitrary Postgres command. This is the combination of the command syntax (repesented by PgSyntax), as well as the type of command (represented by PgCommandType). The command type is necessary for us to know how to retrieve results from the database.

Constructors

PgCommandSyntax
Fields pgCommandType :: PgCommandType fromPgCommand :: PgSyntax

Instances

IsSql92Syntax PgCommandSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92SelectSyntax PgCommandSyntax :: Type # type Sql92InsertSyntax PgCommandSyntax :: Type # type Sql92UpdateSyntax PgCommandSyntax :: Type # type Sql92DeleteSyntax PgCommandSyntax :: Type # Methods selectCmd :: Sql92SelectSyntax PgCommandSyntax -> PgCommandSyntax # insertCmd :: Sql92InsertSyntax PgCommandSyntax -> PgCommandSyntax # updateCmd :: Sql92UpdateSyntax PgCommandSyntax -> PgCommandSyntax # deleteCmd :: Sql92DeleteSyntax PgCommandSyntax -> PgCommandSyntax #
IsSql92DdlCommandSyntax PgCommandSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92DdlCommandCreateTableSyntax PgCommandSyntax :: Type # type Sql92DdlCommandAlterTableSyntax PgCommandSyntax :: Type # type Sql92DdlCommandDropTableSyntax PgCommandSyntax :: Type # Methods createTableCmd :: Sql92DdlCommandCreateTableSyntax PgCommandSyntax -> PgCommandSyntax # dropTableCmd :: Sql92DdlCommandDropTableSyntax PgCommandSyntax -> PgCommandSyntax # alterTableCmd :: Sql92DdlCommandAlterTableSyntax PgCommandSyntax -> PgCommandSyntax #
type Sql92DeleteSyntax PgCommandSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92DeleteSyntax PgCommandSyntax = PgDeleteSyntax
type Sql92UpdateSyntax PgCommandSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92UpdateSyntax PgCommandSyntax = PgUpdateSyntax
type Sql92InsertSyntax PgCommandSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92InsertSyntax PgCommandSyntax = PgInsertSyntax
type Sql92SelectSyntax PgCommandSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92SelectSyntax PgCommandSyntax = PgSelectSyntax
type Sql92DdlCommandDropTableSyntax PgCommandSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92DdlCommandDropTableSyntax PgCommandSyntax
type Sql92DdlCommandAlterTableSyntax PgCommandSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92DdlCommandAlterTableSyntax PgCommandSyntax = PgAlterTableSyntax
type Sql92DdlCommandCreateTableSyntax PgCommandSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92DdlCommandCreateTableSyntax PgCommandSyntax = PgCreateTableSyntax

data PgCommandType Source #

Constructors

PgCommandTypeQuery
PgCommandTypeDdl
PgCommandTypeDataUpdate
PgCommandTypeDataUpdateReturning

Instances

Show PgCommandType Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods showsPrec :: Int -> PgCommandType -> ShowS # show :: PgCommandType -> String # showList :: [PgCommandType] -> ShowS #

newtype PgSelectSyntax Source #

IsSql92SelectSyntax for Postgres

Constructors

PgSelectSyntax
Fields fromPgSelect :: PgSyntax

Instances

IsSql99CommonTableExpressionSelectSyntax PgSelectSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql99SelectCTESyntax PgSelectSyntax :: Type # Methods withSyntax :: [Sql99SelectCTESyntax PgSelectSyntax] -> PgSelectSyntax -> PgSelectSyntax #
IsSql99RecursiveCommonTableExpressionSelectSyntax PgSelectSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods withRecursiveSyntax :: [Sql99SelectCTESyntax PgSelectSyntax] -> PgSelectSyntax -> PgSelectSyntax #
IsSql92SelectSyntax PgSelectSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92SelectSelectTableSyntax PgSelectSyntax :: Type # type Sql92SelectOrderingSyntax PgSelectSyntax :: Type # Methods selectStmt :: Sql92SelectSelectTableSyntax PgSelectSyntax -> [Sql92SelectOrderingSyntax PgSelectSyntax] -> Maybe Integer -> Maybe Integer -> PgSelectSyntax #
type Sql99SelectCTESyntax PgSelectSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql99SelectCTESyntax PgSelectSyntax
type Sql92SelectOrderingSyntax PgSelectSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92SelectOrderingSyntax PgSelectSyntax = PgOrderingSyntax
type Sql92SelectSelectTableSyntax PgSelectSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92SelectSelectTableSyntax PgSelectSyntax

newtype PgSelectSetQuantifierSyntax Source #

Constructors

PgSelectSetQuantifierSyntax
Fields fromPgSelectSetQuantifier :: PgSyntax

Instances

IsSql92AggregationSetQuantifierSyntax PgSelectSetQuantifierSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods setQuantifierDistinct :: PgSelectSetQuantifierSyntax # setQuantifierAll :: PgSelectSetQuantifierSyntax #

newtype PgInsertSyntax Source #

IsSql92InsertSyntax for Postgres

Constructors

PgInsertSyntax
Fields fromPgInsert :: PgSyntax

Instances

IsSql92InsertSyntax PgInsertSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92InsertValuesSyntax PgInsertSyntax :: Type # type Sql92InsertTableNameSyntax PgInsertSyntax :: Type # Methods insertStmt :: Sql92InsertTableNameSyntax PgInsertSyntax -> [Text] -> Sql92InsertValuesSyntax PgInsertSyntax -> PgInsertSyntax #
type Sql92InsertTableNameSyntax PgInsertSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92InsertTableNameSyntax PgInsertSyntax = PgTableNameSyntax
type Sql92InsertValuesSyntax PgInsertSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92InsertValuesSyntax PgInsertSyntax = PgInsertValuesSyntax

newtype PgDeleteSyntax Source #

IsSql92DeleteSyntax for Postgres

Constructors

PgDeleteSyntax
Fields fromPgDelete :: PgSyntax

Instances

IsSql92DeleteSyntax PgDeleteSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92DeleteTableNameSyntax PgDeleteSyntax :: Type # type Sql92DeleteExpressionSyntax PgDeleteSyntax :: Type # Methods deleteStmt :: Sql92DeleteTableNameSyntax PgDeleteSyntax -> Maybe Text -> Maybe (Sql92DeleteExpressionSyntax PgDeleteSyntax) -> PgDeleteSyntax # deleteSupportsAlias :: Proxy PgDeleteSyntax -> Bool #
type Sql92DeleteExpressionSyntax PgDeleteSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92DeleteExpressionSyntax PgDeleteSyntax = PgExpressionSyntax
type Sql92DeleteTableNameSyntax PgDeleteSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92DeleteTableNameSyntax PgDeleteSyntax = PgTableNameSyntax

newtype PgUpdateSyntax Source #

IsSql92UpdateSyntax for Postgres

Constructors

PgUpdateSyntax
Fields fromPgUpdate :: PgSyntax

Instances

IsSql92UpdateSyntax PgUpdateSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92UpdateTableNameSyntax PgUpdateSyntax :: Type # type Sql92UpdateFieldNameSyntax PgUpdateSyntax :: Type # type Sql92UpdateExpressionSyntax PgUpdateSyntax :: Type # Methods updateStmt :: Sql92UpdateTableNameSyntax PgUpdateSyntax -> [(Sql92UpdateFieldNameSyntax PgUpdateSyntax, Sql92UpdateExpressionSyntax PgUpdateSyntax)] -> Maybe (Sql92UpdateExpressionSyntax PgUpdateSyntax) -> PgUpdateSyntax #
type Sql92UpdateExpressionSyntax PgUpdateSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92UpdateExpressionSyntax PgUpdateSyntax = PgExpressionSyntax
type Sql92UpdateFieldNameSyntax PgUpdateSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92UpdateFieldNameSyntax PgUpdateSyntax = PgFieldNameSyntax
type Sql92UpdateTableNameSyntax PgUpdateSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92UpdateTableNameSyntax PgUpdateSyntax = PgTableNameSyntax

newtype PgExpressionSyntax Source #

Constructors

PgExpressionSyntax
Fields fromPgExpression :: PgSyntax

Instances

Eq PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods (==) :: PgExpressionSyntax -> PgExpressionSyntax -> Bool # (/=) :: PgExpressionSyntax -> PgExpressionSyntax -> Bool #
IsCustomSqlSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types data CustomSqlSyntax PgExpressionSyntax :: Type # Methods customExprSyntax :: CustomSqlSyntax PgExpressionSyntax -> PgExpressionSyntax # renderSyntax :: PgExpressionSyntax -> CustomSqlSyntax PgExpressionSyntax #
IsSql2003ExpressionSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql2003ExpressionWindowFrameSyntax PgExpressionSyntax :: Type # Methods overE :: PgExpressionSyntax -> Sql2003ExpressionWindowFrameSyntax PgExpressionSyntax -> PgExpressionSyntax # rowNumberE :: PgExpressionSyntax #
IsSql2003ExpressionAdvancedOLAPOperationsSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods percentRankAggE :: PgExpressionSyntax # denseRankAggE :: PgExpressionSyntax # cumeDistAggE :: PgExpressionSyntax #
IsSql2003ExpressionElementaryOLAPOperationsSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods filterAggE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # rankAggE :: PgExpressionSyntax #
IsSql2003EnhancedNumericFunctionsExpressionSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods lnE :: PgExpressionSyntax -> PgExpressionSyntax # expE :: PgExpressionSyntax -> PgExpressionSyntax # sqrtE :: PgExpressionSyntax -> PgExpressionSyntax # ceilE :: PgExpressionSyntax -> PgExpressionSyntax # floorE :: PgExpressionSyntax -> PgExpressionSyntax # powerE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax #
IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods stddevPopE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax # stddevSampE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax # varPopE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax # varSampE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax # covarPopE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # covarSampE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # corrE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # regrSlopeE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # regrInterceptE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # regrCountE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # regrRSquaredE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # regrAvgXE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # regrAvgYE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # regrSXXE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # regrSXYE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # regrSYYE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax #
IsSql2003NtileExpressionSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods ntileE :: PgExpressionSyntax -> PgExpressionSyntax #
IsSql2003LeadAndLagExpressionSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods leadE :: PgExpressionSyntax -> Maybe PgExpressionSyntax -> Maybe PgExpressionSyntax -> PgExpressionSyntax # lagE :: PgExpressionSyntax -> Maybe PgExpressionSyntax -> Maybe PgExpressionSyntax -> PgExpressionSyntax #
IsSql2003FirstValueAndLastValueExpressionSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods firstValueE :: PgExpressionSyntax -> PgExpressionSyntax # lastValueE :: PgExpressionSyntax -> PgExpressionSyntax #
IsSql2003NthValueExpressionSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods nthValueE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax #
IsSql99FunctionExpressionSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods functionCallE :: PgExpressionSyntax -> [PgExpressionSyntax] -> PgExpressionSyntax # functionNameE :: Text -> PgExpressionSyntax #
IsSql99ExpressionSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods distinctE :: Sql92ExpressionSelectSyntax PgExpressionSyntax -> PgExpressionSyntax # similarToE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # instanceFieldE :: PgExpressionSyntax -> Text -> PgExpressionSyntax # refFieldE :: PgExpressionSyntax -> Text -> PgExpressionSyntax #
IsSql99ConcatExpressionSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods concatE :: [PgExpressionSyntax] -> PgExpressionSyntax #
IsSql99AggregationExpressionSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods everyE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax # someE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax # anyE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax #
IsSql92ExpressionSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92ExpressionQuantifierSyntax PgExpressionSyntax :: Type # type Sql92ExpressionValueSyntax PgExpressionSyntax :: Type # type Sql92ExpressionSelectSyntax PgExpressionSyntax :: Type # type Sql92ExpressionFieldNameSyntax PgExpressionSyntax :: Type # type Sql92ExpressionCastTargetSyntax PgExpressionSyntax :: Type # type Sql92ExpressionExtractFieldSyntax PgExpressionSyntax :: Type # Methods valueE :: Sql92ExpressionValueSyntax PgExpressionSyntax -> PgExpressionSyntax # rowE :: [PgExpressionSyntax] -> PgExpressionSyntax # quantifierListE :: [PgExpressionSyntax] -> PgExpressionSyntax # coalesceE :: [PgExpressionSyntax] -> PgExpressionSyntax # caseE :: [(PgExpressionSyntax, PgExpressionSyntax)] -> PgExpressionSyntax -> PgExpressionSyntax # fieldE :: Sql92ExpressionFieldNameSyntax PgExpressionSyntax -> PgExpressionSyntax # betweenE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # andE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # orE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # addE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # subE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # mulE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # divE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # likeE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # modE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # overlapsE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # nullIfE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # positionE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # eqE :: Maybe (Sql92ExpressionQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # neqE :: Maybe (Sql92ExpressionQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # ltE :: Maybe (Sql92ExpressionQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # gtE :: Maybe (Sql92ExpressionQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # leE :: Maybe (Sql92ExpressionQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # geE :: Maybe (Sql92ExpressionQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # eqMaybeE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # neqMaybeE :: PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # castE :: PgExpressionSyntax -> Sql92ExpressionCastTargetSyntax PgExpressionSyntax -> PgExpressionSyntax # notE :: PgExpressionSyntax -> PgExpressionSyntax # negateE :: PgExpressionSyntax -> PgExpressionSyntax # isNullE :: PgExpressionSyntax -> PgExpressionSyntax # isNotNullE :: PgExpressionSyntax -> PgExpressionSyntax # isTrueE :: PgExpressionSyntax -> PgExpressionSyntax # isNotTrueE :: PgExpressionSyntax -> PgExpressionSyntax # isFalseE :: PgExpressionSyntax -> PgExpressionSyntax # isNotFalseE :: PgExpressionSyntax -> PgExpressionSyntax # isUnknownE :: PgExpressionSyntax -> PgExpressionSyntax # isNotUnknownE :: PgExpressionSyntax -> PgExpressionSyntax # charLengthE :: PgExpressionSyntax -> PgExpressionSyntax # octetLengthE :: PgExpressionSyntax -> PgExpressionSyntax # bitLengthE :: PgExpressionSyntax -> PgExpressionSyntax # lowerE :: PgExpressionSyntax -> PgExpressionSyntax # upperE :: PgExpressionSyntax -> PgExpressionSyntax # trimE :: PgExpressionSyntax -> PgExpressionSyntax # absE :: PgExpressionSyntax -> PgExpressionSyntax # extractE :: Sql92ExpressionExtractFieldSyntax PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax # existsE :: Sql92ExpressionSelectSyntax PgExpressionSyntax -> PgExpressionSyntax # uniqueE :: Sql92ExpressionSelectSyntax PgExpressionSyntax -> PgExpressionSyntax # subqueryE :: Sql92ExpressionSelectSyntax PgExpressionSyntax -> PgExpressionSyntax # currentTimestampE :: PgExpressionSyntax # defaultE :: PgExpressionSyntax # inE :: PgExpressionSyntax -> [PgExpressionSyntax] -> PgExpressionSyntax #
IsSql92AggregationExpressionSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92AggregationSetQuantifierSyntax PgExpressionSyntax :: Type # Methods countAllE :: PgExpressionSyntax # countE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax # avgE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax # maxE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax # minE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax # sumE :: Maybe (Sql92AggregationSetQuantifierSyntax PgExpressionSyntax) -> PgExpressionSyntax -> PgExpressionSyntax #
IsString (CustomSqlSyntax PgExpressionSyntax) Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods fromString :: String -> CustomSqlSyntax PgExpressionSyntax #
Semigroup (CustomSqlSyntax PgExpressionSyntax) Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods (<>) :: CustomSqlSyntax PgExpressionSyntax -> CustomSqlSyntax PgExpressionSyntax -> CustomSqlSyntax PgExpressionSyntax # sconcat :: NonEmpty (CustomSqlSyntax PgExpressionSyntax) -> CustomSqlSyntax PgExpressionSyntax # stimes :: Integral b => b -> CustomSqlSyntax PgExpressionSyntax -> CustomSqlSyntax PgExpressionSyntax #
Monoid (CustomSqlSyntax PgExpressionSyntax) Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods mempty :: CustomSqlSyntax PgExpressionSyntax # mappend :: CustomSqlSyntax PgExpressionSyntax -> CustomSqlSyntax PgExpressionSyntax -> CustomSqlSyntax PgExpressionSyntax # mconcat :: [CustomSqlSyntax PgExpressionSyntax] -> CustomSqlSyntax PgExpressionSyntax #
newtype CustomSqlSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax newtype CustomSqlSyntax PgExpressionSyntax = PgCustomExpressionSyntax { fromPgCustomExpression :: PgSyntax }
type Sql2003ExpressionWindowFrameSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql2003ExpressionWindowFrameSyntax PgExpressionSyntax = PgWindowFrameSyntax
type Sql92ExpressionExtractFieldSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92ExpressionExtractFieldSyntax PgExpressionSyntax = PgExtractFieldSyntax
type Sql92ExpressionCastTargetSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92ExpressionCastTargetSyntax PgExpressionSyntax = PgDataTypeSyntax
type Sql92ExpressionFieldNameSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92ExpressionFieldNameSyntax PgExpressionSyntax = PgFieldNameSyntax
type Sql92ExpressionSelectSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92ExpressionSelectSyntax PgExpressionSyntax = PgSelectSyntax
type Sql92ExpressionValueSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92ExpressionValueSyntax PgExpressionSyntax = PgValueSyntax
type Sql92ExpressionQuantifierSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92ExpressionQuantifierSyntax PgExpressionSyntax = PgComparisonQuantifierSyntax
type Sql92AggregationSetQuantifierSyntax PgExpressionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92AggregationSetQuantifierSyntax PgExpressionSyntax = PgAggregationSetQuantifierSyntax

newtype PgFromSyntax Source #

Constructors

PgFromSyntax
Fields fromPgFrom :: PgSyntax

Instances

IsSql92FromSyntax PgFromSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92FromTableSourceSyntax PgFromSyntax :: Type # type Sql92FromExpressionSyntax PgFromSyntax :: Type # Methods fromTable :: Sql92FromTableSourceSyntax PgFromSyntax -> Maybe (Text, Maybe [Text]) -> PgFromSyntax # innerJoin :: PgFromSyntax -> PgFromSyntax -> Maybe (Sql92FromExpressionSyntax PgFromSyntax) -> PgFromSyntax # leftJoin :: PgFromSyntax -> PgFromSyntax -> Maybe (Sql92FromExpressionSyntax PgFromSyntax) -> PgFromSyntax # rightJoin :: PgFromSyntax -> PgFromSyntax -> Maybe (Sql92FromExpressionSyntax PgFromSyntax) -> PgFromSyntax #
IsSql92FromOuterJoinSyntax PgFromSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods outerJoin :: PgFromSyntax -> PgFromSyntax -> Maybe (Sql92FromExpressionSyntax PgFromSyntax) -> PgFromSyntax #
type Sql92FromExpressionSyntax PgFromSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92FromExpressionSyntax PgFromSyntax = PgExpressionSyntax
type Sql92FromTableSourceSyntax PgFromSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92FromTableSourceSyntax PgFromSyntax = PgTableSourceSyntax

newtype PgTableNameSyntax Source #

Constructors

PgTableNameSyntax
Fields fromPgTableName :: PgSyntax

Instances

IsSql92TableNameSyntax PgTableNameSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods tableName :: Maybe Text -> Text -> PgTableNameSyntax #

newtype PgComparisonQuantifierSyntax Source #

Constructors

PgComparisonQuantifierSyntax
Fields fromPgComparisonQuantifier :: PgSyntax

Instances

IsSql92QuantifierSyntax PgComparisonQuantifierSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods quantifyOverAll :: PgComparisonQuantifierSyntax # quantifyOverAny :: PgComparisonQuantifierSyntax #

newtype PgExtractFieldSyntax Source #

Constructors

PgExtractFieldSyntax
Fields fromPgExtractField :: PgSyntax

Instances

IsSql92ExtractFieldSyntax PgExtractFieldSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods secondsField :: PgExtractFieldSyntax # minutesField :: PgExtractFieldSyntax # hourField :: PgExtractFieldSyntax # dayField :: PgExtractFieldSyntax # monthField :: PgExtractFieldSyntax # yearField :: PgExtractFieldSyntax #

newtype PgProjectionSyntax Source #

Constructors

PgProjectionSyntax
Fields fromPgProjection :: PgSyntax

Instances

IsSql92ProjectionSyntax PgProjectionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92ProjectionExpressionSyntax PgProjectionSyntax :: Type # Methods projExprs :: [(Sql92ProjectionExpressionSyntax PgProjectionSyntax, Maybe Text)] -> PgProjectionSyntax #
type Sql92ProjectionExpressionSyntax PgProjectionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92ProjectionExpressionSyntax PgProjectionSyntax = PgExpressionSyntax

newtype PgGroupingSyntax Source #

Constructors

PgGroupingSyntax
Fields fromPgGrouping :: PgSyntax

Instances

IsSql92GroupingSyntax PgGroupingSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92GroupingExpressionSyntax PgGroupingSyntax :: Type # Methods groupByExpressions :: [Sql92GroupingExpressionSyntax PgGroupingSyntax] -> PgGroupingSyntax #
type Sql92GroupingExpressionSyntax PgGroupingSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92GroupingExpressionSyntax PgGroupingSyntax = PgExpressionSyntax

data PgOrderingSyntax Source #

Constructors

PgOrderingSyntax
Fields pgOrderingSyntax :: PgSyntax pgOrderingNullOrdering :: Maybe PgNullOrdering

Instances

IsSql2003OrderingElementaryOLAPOperationsSyntax PgOrderingSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods nullsFirstOrdering :: PgOrderingSyntax -> PgOrderingSyntax # nullsLastOrdering :: PgOrderingSyntax -> PgOrderingSyntax #
IsSql92OrderingSyntax PgOrderingSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92OrderingExpressionSyntax PgOrderingSyntax :: Type # Methods ascOrdering :: Sql92OrderingExpressionSyntax PgOrderingSyntax -> PgOrderingSyntax # descOrdering :: Sql92OrderingExpressionSyntax PgOrderingSyntax -> PgOrderingSyntax #
type Sql92OrderingExpressionSyntax PgOrderingSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92OrderingExpressionSyntax PgOrderingSyntax = PgExpressionSyntax

newtype PgValueSyntax Source #

Constructors

PgValueSyntax
Fields fromPgValue :: PgSyntax

Instances

HasSqlValueSyntax PgValueSyntax Bool Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Bool -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Double Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Double -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Float Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Float -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Int Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Int -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Int8 Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Int8 -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Int16 Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Int16 -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Int32 Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Int32 -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Int64 Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Int64 -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Integer Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Integer -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Word Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Word -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Word8 Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Word8 -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Word16 Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Word16 -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Word32 Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Word32 -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Word64 Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Word64 -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax ByteString Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: ByteString -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax ByteString Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: ByteString -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Scientific Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Scientific -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Text Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Text -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax UTCTime Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: UTCTime -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Value Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Value -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Text Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Text -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax SqlNull Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: SqlNull -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Oid Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Oid -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax HStoreBuilder Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: HStoreBuilder -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax HStoreList Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: HStoreList -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax HStoreMap Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: HStoreMap -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax LocalTimestamp Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: LocalTimestamp -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax UTCTimestamp Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: UTCTimestamp -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Date Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Date -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax LocalTime Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: LocalTime -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax TimeOfDay Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: TimeOfDay -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax NominalDiffTime Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: NominalDiffTime -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax Day Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Day -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax UUID Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: UUID -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax PgBox Source #
Instance details Defined in Database.Beam.Postgres.PgSpecific Methods sqlValueSyntax :: PgBox -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax PgLineSegment Source #
Instance details Defined in Database.Beam.Postgres.PgSpecific Methods sqlValueSyntax :: PgLineSegment -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax PgLine Source #
Instance details Defined in Database.Beam.Postgres.PgSpecific Methods sqlValueSyntax :: PgLine -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax PgPoint Source #
Instance details Defined in Database.Beam.Postgres.PgSpecific Methods sqlValueSyntax :: PgPoint -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax PgMoney Source #
Instance details Defined in Database.Beam.Postgres.PgSpecific Methods sqlValueSyntax :: PgMoney -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax [Char] Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: [Char] -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax x => HasSqlValueSyntax PgValueSyntax (Maybe x) Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Maybe x -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax (CI Text) Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: CI Text -> PgValueSyntax #
HasSqlValueSyntax PgValueSyntax (CI Text) Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: CI Text -> PgValueSyntax #
ToField a => HasSqlValueSyntax PgValueSyntax (Vector a) Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods sqlValueSyntax :: Vector a -> PgValueSyntax #
ToJSON a => HasSqlValueSyntax PgValueSyntax (PgJSONB a) Source #
Instance details Defined in Database.Beam.Postgres.PgSpecific Methods sqlValueSyntax :: PgJSONB a -> PgValueSyntax #
ToJSON a => HasSqlValueSyntax PgValueSyntax (PgJSON a) Source #
Instance details Defined in Database.Beam.Postgres.PgSpecific Methods sqlValueSyntax :: PgJSON a -> PgValueSyntax #
(HasSqlValueSyntax PgValueSyntax a, PgIsRange n) => HasSqlValueSyntax PgValueSyntax (PgRange n a) Source #
Instance details Defined in Database.Beam.Postgres.PgSpecific Methods sqlValueSyntax :: PgRange n a -> PgValueSyntax #

newtype PgTableSourceSyntax Source #

Constructors

PgTableSourceSyntax
Fields fromPgTableSource :: PgSyntax

Instances

IsSql92TableSourceSyntax PgTableSourceSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92TableSourceSelectSyntax PgTableSourceSyntax :: Type # type Sql92TableSourceExpressionSyntax PgTableSourceSyntax :: Type # type Sql92TableSourceTableNameSyntax PgTableSourceSyntax :: Type # Methods tableNamed :: Sql92TableSourceTableNameSyntax PgTableSourceSyntax -> PgTableSourceSyntax # tableFromSubSelect :: Sql92TableSourceSelectSyntax PgTableSourceSyntax -> PgTableSourceSyntax # tableFromValues :: [[Sql92TableSourceExpressionSyntax PgTableSourceSyntax]] -> PgTableSourceSyntax #
type Sql92TableSourceTableNameSyntax PgTableSourceSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92TableSourceTableNameSyntax PgTableSourceSyntax = PgTableNameSyntax
type Sql92TableSourceExpressionSyntax PgTableSourceSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92TableSourceExpressionSyntax PgTableSourceSyntax = PgExpressionSyntax
type Sql92TableSourceSelectSyntax PgTableSourceSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92TableSourceSelectSyntax PgTableSourceSyntax = PgSelectSyntax

newtype PgFieldNameSyntax Source #

Constructors

PgFieldNameSyntax
Fields fromPgFieldName :: PgSyntax

Instances

IsSql92FieldNameSyntax PgFieldNameSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods qualifiedField :: Text -> Text -> PgFieldNameSyntax # unqualifiedField :: Text -> PgFieldNameSyntax #

newtype PgAggregationSetQuantifierSyntax Source #

Constructors

PgAggregationSetQuantifierSyntax
Fields fromPgAggregationSetQuantifier :: PgSyntax

Instances

IsSql92AggregationSetQuantifierSyntax PgAggregationSetQuantifierSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods setQuantifierDistinct :: PgAggregationSetQuantifierSyntax # setQuantifierAll :: PgAggregationSetQuantifierSyntax #

newtype PgInsertValuesSyntax Source #

Constructors

PgInsertValuesSyntax
Fields fromPgInsertValues :: PgSyntax

Instances

IsSql92InsertValuesSyntax PgInsertValuesSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92InsertValuesExpressionSyntax PgInsertValuesSyntax :: Type # type Sql92InsertValuesSelectSyntax PgInsertValuesSyntax :: Type # Methods insertSqlExpressions :: [[Sql92InsertValuesExpressionSyntax PgInsertValuesSyntax]] -> PgInsertValuesSyntax # insertFromSql :: Sql92InsertValuesSelectSyntax PgInsertValuesSyntax -> PgInsertValuesSyntax #
type Sql92InsertValuesSelectSyntax PgInsertValuesSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92InsertValuesSelectSyntax PgInsertValuesSyntax = PgSelectSyntax
type Sql92InsertValuesExpressionSyntax PgInsertValuesSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92InsertValuesExpressionSyntax PgInsertValuesSyntax = PgExpressionSyntax

newtype PgInsertOnConflictSyntax Source #

Constructors

PgInsertOnConflictSyntax
Fields fromPgInsertOnConflict :: PgSyntax

newtype PgInsertOnConflictTargetSyntax Source #

Constructors

PgInsertOnConflictTargetSyntax
Fields fromPgInsertOnConflictTarget :: PgSyntax

newtype PgConflictActionSyntax Source #

Constructors

PgConflictActionSyntax
Fields fromPgConflictAction :: PgSyntax

newtype PgCreateTableSyntax Source #

Constructors

PgCreateTableSyntax
Fields fromPgCreateTable :: PgSyntax

Instances

IsSql92CreateTableSyntax PgCreateTableSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92CreateTableTableNameSyntax PgCreateTableSyntax :: Type # type Sql92CreateTableColumnSchemaSyntax PgCreateTableSyntax :: Type # type Sql92CreateTableTableConstraintSyntax PgCreateTableSyntax :: Type # type Sql92CreateTableOptionsSyntax PgCreateTableSyntax :: Type # Methods createTableSyntax :: Maybe (Sql92CreateTableOptionsSyntax PgCreateTableSyntax) -> Sql92CreateTableTableNameSyntax PgCreateTableSyntax -> [(Text, Sql92CreateTableColumnSchemaSyntax PgCreateTableSyntax)] -> [Sql92CreateTableTableConstraintSyntax PgCreateTableSyntax] -> PgCreateTableSyntax #
type Sql92CreateTableOptionsSyntax PgCreateTableSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92CreateTableOptionsSyntax PgCreateTableSyntax = PgTableOptionsSyntax
type Sql92CreateTableTableConstraintSyntax PgCreateTableSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92CreateTableTableConstraintSyntax PgCreateTableSyntax = PgTableConstraintSyntax
type Sql92CreateTableColumnSchemaSyntax PgCreateTableSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92CreateTableColumnSchemaSyntax PgCreateTableSyntax = PgColumnSchemaSyntax
type Sql92CreateTableTableNameSyntax PgCreateTableSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92CreateTableTableNameSyntax PgCreateTableSyntax = PgTableNameSyntax

data PgTableOptionsSyntax Source #

Constructors

PgTableOptionsSyntax PgSyntax PgSyntax

newtype PgColumnSchemaSyntax Source #

Constructors

PgColumnSchemaSyntax
Fields fromPgColumnSchema :: PgSyntax

Instances

Eq PgColumnSchemaSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods (==) :: PgColumnSchemaSyntax -> PgColumnSchemaSyntax -> Bool # (/=) :: PgColumnSchemaSyntax -> PgColumnSchemaSyntax -> Bool #
Show PgColumnSchemaSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods showsPrec :: Int -> PgColumnSchemaSyntax -> ShowS # show :: PgColumnSchemaSyntax -> String # showList :: [PgColumnSchemaSyntax] -> ShowS #
Hashable PgColumnSchemaSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods hashWithSalt :: Int -> PgColumnSchemaSyntax -> Int # hash :: PgColumnSchemaSyntax -> Int #
Sql92DisplaySyntax PgColumnSchemaSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods displaySyntax :: PgColumnSchemaSyntax -> String #
IsSql92ColumnSchemaSyntax PgColumnSchemaSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92ColumnSchemaColumnTypeSyntax PgColumnSchemaSyntax :: Type # type Sql92ColumnSchemaExpressionSyntax PgColumnSchemaSyntax :: Type # type Sql92ColumnSchemaColumnConstraintDefinitionSyntax PgColumnSchemaSyntax :: Type # Methods columnSchemaSyntax :: Sql92ColumnSchemaColumnTypeSyntax PgColumnSchemaSyntax -> Maybe (Sql92ColumnSchemaExpressionSyntax PgColumnSchemaSyntax) -> [Sql92ColumnSchemaColumnConstraintDefinitionSyntax PgColumnSchemaSyntax] -> Maybe Text -> PgColumnSchemaSyntax #
type Sql92ColumnSchemaColumnConstraintDefinitionSyntax PgColumnSchemaSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92ColumnSchemaColumnConstraintDefinitionSyntax PgColumnSchemaSyntax = PgColumnConstraintDefinitionSyntax
type Sql92ColumnSchemaExpressionSyntax PgColumnSchemaSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92ColumnSchemaExpressionSyntax PgColumnSchemaSyntax = PgExpressionSyntax
type Sql92ColumnSchemaColumnTypeSyntax PgColumnSchemaSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92ColumnSchemaColumnTypeSyntax PgColumnSchemaSyntax = PgDataTypeSyntax

data PgDataTypeSyntax Source #

Constructors

PgDataTypeSyntax
Fields pgDataTypeDescr :: PgDataTypeDescr fromPgDataType :: PgSyntax pgDataTypeSerialized :: BeamSerializedDataType

Instances

Eq PgDataTypeSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods (==) :: PgDataTypeSyntax -> PgDataTypeSyntax -> Bool # (/=) :: PgDataTypeSyntax -> PgDataTypeSyntax -> Bool #
Show PgDataTypeSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods showsPrec :: Int -> PgDataTypeSyntax -> ShowS # show :: PgDataTypeSyntax -> String # showList :: [PgDataTypeSyntax] -> ShowS #
Hashable PgDataTypeSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods hashWithSalt :: Int -> PgDataTypeSyntax -> Int # hash :: PgDataTypeSyntax -> Int #
IsSql2008BigIntDataTypeSyntax PgDataTypeSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods bigIntType :: PgDataTypeSyntax #
IsSql99DataTypeSyntax PgDataTypeSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods characterLargeObjectType :: PgDataTypeSyntax # binaryLargeObjectType :: PgDataTypeSyntax # booleanType :: PgDataTypeSyntax # arrayType :: PgDataTypeSyntax -> Int -> PgDataTypeSyntax # rowType :: [(Text, PgDataTypeSyntax)] -> PgDataTypeSyntax #
Sql92DisplaySyntax PgDataTypeSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods displaySyntax :: PgDataTypeSyntax -> String #
IsSql92DataTypeSyntax PgDataTypeSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods domainType :: Text -> PgDataTypeSyntax # charType :: Maybe Word -> Maybe Text -> PgDataTypeSyntax # varCharType :: Maybe Word -> Maybe Text -> PgDataTypeSyntax # nationalCharType :: Maybe Word -> PgDataTypeSyntax # nationalVarCharType :: Maybe Word -> PgDataTypeSyntax # bitType :: Maybe Word -> PgDataTypeSyntax # varBitType :: Maybe Word -> PgDataTypeSyntax # numericType :: Maybe (Word, Maybe Word) -> PgDataTypeSyntax # decimalType :: Maybe (Word, Maybe Word) -> PgDataTypeSyntax # intType :: PgDataTypeSyntax # smallIntType :: PgDataTypeSyntax # floatType :: Maybe Word -> PgDataTypeSyntax # doubleType :: PgDataTypeSyntax # realType :: PgDataTypeSyntax # dateType :: PgDataTypeSyntax # timeType :: Maybe Word -> Bool -> PgDataTypeSyntax # timestampType :: Maybe Word -> Bool -> PgDataTypeSyntax #
HasDataTypeCreatedCheck PgDataTypeSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods dataTypeHasBeenCreated :: PgDataTypeSyntax -> (forall preCondition. Typeable preCondition => [preCondition]) -> Bool #
Sql92SerializableDataTypeSyntax PgDataTypeSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods serializeDataType :: PgDataTypeSyntax -> Value #

data PgColumnConstraintDefinitionSyntax Source #

Constructors

PgColumnConstraintDefinitionSyntax
Fields fromPgColumnConstraintDefinition :: PgSyntax pgColumnConstraintDefinitionSerialized :: BeamSerializedConstraintDefinition

Instances

Eq PgColumnConstraintDefinitionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods (==) :: PgColumnConstraintDefinitionSyntax -> PgColumnConstraintDefinitionSyntax -> Bool # (/=) :: PgColumnConstraintDefinitionSyntax -> PgColumnConstraintDefinitionSyntax -> Bool #
Show PgColumnConstraintDefinitionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods showsPrec :: Int -> PgColumnConstraintDefinitionSyntax -> ShowS # show :: PgColumnConstraintDefinitionSyntax -> String # showList :: [PgColumnConstraintDefinitionSyntax] -> ShowS #
Hashable PgColumnConstraintDefinitionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods hashWithSalt :: Int -> PgColumnConstraintDefinitionSyntax -> Int # hash :: PgColumnConstraintDefinitionSyntax -> Int #
Sql92DisplaySyntax PgColumnConstraintDefinitionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods displaySyntax :: PgColumnConstraintDefinitionSyntax -> String #
IsSql92ColumnConstraintDefinitionSyntax PgColumnConstraintDefinitionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92ColumnConstraintDefinitionConstraintSyntax PgColumnConstraintDefinitionSyntax :: Type # type Sql92ColumnConstraintDefinitionAttributesSyntax PgColumnConstraintDefinitionSyntax :: Type # Methods constraintDefinitionSyntax :: Maybe Text -> Sql92ColumnConstraintDefinitionConstraintSyntax PgColumnConstraintDefinitionSyntax -> Maybe (Sql92ColumnConstraintDefinitionAttributesSyntax PgColumnConstraintDefinitionSyntax) -> PgColumnConstraintDefinitionSyntax #
Sql92SerializableConstraintDefinitionSyntax PgColumnConstraintDefinitionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods serializeConstraint :: PgColumnConstraintDefinitionSyntax -> Value #
type Sql92ColumnConstraintDefinitionAttributesSyntax PgColumnConstraintDefinitionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92ColumnConstraintDefinitionAttributesSyntax PgColumnConstraintDefinitionSyntax = SqlConstraintAttributesBuilder
type Sql92ColumnConstraintDefinitionConstraintSyntax PgColumnConstraintDefinitionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92ColumnConstraintDefinitionConstraintSyntax PgColumnConstraintDefinitionSyntax = PgColumnConstraintSyntax

data PgColumnConstraintSyntax Source #

Constructors

PgColumnConstraintSyntax
Fields fromPgColumnConstraint :: PgSyntax pgColumnConstraintSerialized :: BeamSerializedConstraint

Instances

IsSql92ColumnConstraintSyntax PgColumnConstraintSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92ColumnConstraintMatchTypeSyntax PgColumnConstraintSyntax :: Type # type Sql92ColumnConstraintReferentialActionSyntax PgColumnConstraintSyntax :: Type # type Sql92ColumnConstraintExpressionSyntax PgColumnConstraintSyntax :: Type # Methods notNullConstraintSyntax :: PgColumnConstraintSyntax # uniqueColumnConstraintSyntax :: PgColumnConstraintSyntax # primaryKeyColumnConstraintSyntax :: PgColumnConstraintSyntax # checkColumnConstraintSyntax :: Sql92ColumnConstraintExpressionSyntax PgColumnConstraintSyntax -> PgColumnConstraintSyntax # referencesConstraintSyntax :: Text -> [Text] -> Maybe (Sql92ColumnConstraintMatchTypeSyntax PgColumnConstraintSyntax) -> Maybe (Sql92ColumnConstraintReferentialActionSyntax PgColumnConstraintSyntax) -> Maybe (Sql92ColumnConstraintReferentialActionSyntax PgColumnConstraintSyntax) -> PgColumnConstraintSyntax #
type Sql92ColumnConstraintExpressionSyntax PgColumnConstraintSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92ColumnConstraintExpressionSyntax PgColumnConstraintSyntax = PgExpressionSyntax
type Sql92ColumnConstraintReferentialActionSyntax PgColumnConstraintSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92ColumnConstraintReferentialActionSyntax PgColumnConstraintSyntax = PgReferentialActionSyntax
type Sql92ColumnConstraintMatchTypeSyntax PgColumnConstraintSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92ColumnConstraintMatchTypeSyntax PgColumnConstraintSyntax = PgMatchTypeSyntax

newtype PgTableConstraintSyntax Source #

Constructors

PgTableConstraintSyntax
Fields fromPgTableConstraint :: PgSyntax

Instances

IsSql92TableConstraintSyntax PgTableConstraintSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods primaryKeyConstraintSyntax :: [Text] -> PgTableConstraintSyntax #

data PgMatchTypeSyntax Source #

Constructors

PgMatchTypeSyntax
Fields fromPgMatchType :: PgSyntax pgMatchTypeSerialized :: BeamSerializedMatchType

Instances

IsSql92MatchTypeSyntax PgMatchTypeSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods fullMatchSyntax :: PgMatchTypeSyntax # partialMatchSyntax :: PgMatchTypeSyntax #

newtype PgAlterTableSyntax Source #

Constructors

PgAlterTableSyntax
Fields fromPgAlterTable :: PgSyntax

Instances

IsSql92AlterTableSyntax PgAlterTableSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92AlterTableTableNameSyntax PgAlterTableSyntax :: Type # type Sql92AlterTableAlterTableActionSyntax PgAlterTableSyntax :: Type # Methods alterTableSyntax :: Sql92AlterTableTableNameSyntax PgAlterTableSyntax -> Sql92AlterTableAlterTableActionSyntax PgAlterTableSyntax -> PgAlterTableSyntax #
type Sql92AlterTableAlterTableActionSyntax PgAlterTableSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92AlterTableAlterTableActionSyntax PgAlterTableSyntax = PgAlterTableActionSyntax
type Sql92AlterTableTableNameSyntax PgAlterTableSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92AlterTableTableNameSyntax PgAlterTableSyntax = PgTableNameSyntax

newtype PgAlterTableActionSyntax Source #

Constructors

PgAlterTableActionSyntax
Fields fromPgAlterTableAction :: PgSyntax

Instances

IsSql92AlterTableActionSyntax PgAlterTableActionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql92AlterTableAlterColumnActionSyntax PgAlterTableActionSyntax :: Type # type Sql92AlterTableColumnSchemaSyntax PgAlterTableActionSyntax :: Type # Methods alterColumnSyntax :: Text -> Sql92AlterTableAlterColumnActionSyntax PgAlterTableActionSyntax -> PgAlterTableActionSyntax # addColumnSyntax :: Text -> Sql92AlterTableColumnSchemaSyntax PgAlterTableActionSyntax -> PgAlterTableActionSyntax # dropColumnSyntax :: Text -> PgAlterTableActionSyntax # renameTableToSyntax :: Text -> PgAlterTableActionSyntax # renameColumnToSyntax :: Text -> Text -> PgAlterTableActionSyntax #
type Sql92AlterTableColumnSchemaSyntax PgAlterTableActionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92AlterTableColumnSchemaSyntax PgAlterTableActionSyntax = PgColumnSchemaSyntax
type Sql92AlterTableAlterColumnActionSyntax PgAlterTableActionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql92AlterTableAlterColumnActionSyntax PgAlterTableActionSyntax = PgAlterColumnActionSyntax

newtype PgAlterColumnActionSyntax Source #

Constructors

PgAlterColumnActionSyntax
Fields fromPgAlterColumnAction :: PgSyntax

Instances

IsSql92AlterColumnActionSyntax PgAlterColumnActionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods setNotNullSyntax :: PgAlterColumnActionSyntax # setNullSyntax :: PgAlterColumnActionSyntax #

newtype PgWindowFrameSyntax Source #

Constructors

PgWindowFrameSyntax
Fields fromPgWindowFrame :: PgSyntax

Instances

IsSql2003WindowFrameSyntax PgWindowFrameSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql2003WindowFrameExpressionSyntax PgWindowFrameSyntax :: Type # type Sql2003WindowFrameOrderingSyntax PgWindowFrameSyntax :: Type # type Sql2003WindowFrameBoundsSyntax PgWindowFrameSyntax :: Type # Methods frameSyntax :: Maybe [Sql2003WindowFrameExpressionSyntax PgWindowFrameSyntax] -> Maybe [Sql2003WindowFrameOrderingSyntax PgWindowFrameSyntax] -> Maybe (Sql2003WindowFrameBoundsSyntax PgWindowFrameSyntax) -> PgWindowFrameSyntax #
type Sql2003WindowFrameBoundsSyntax PgWindowFrameSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql2003WindowFrameBoundsSyntax PgWindowFrameSyntax = PgWindowFrameBoundsSyntax
type Sql2003WindowFrameOrderingSyntax PgWindowFrameSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql2003WindowFrameOrderingSyntax PgWindowFrameSyntax = PgOrderingSyntax
type Sql2003WindowFrameExpressionSyntax PgWindowFrameSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql2003WindowFrameExpressionSyntax PgWindowFrameSyntax = PgExpressionSyntax

newtype PgWindowFrameBoundsSyntax Source #

Constructors

PgWindowFrameBoundsSyntax
Fields fromPgWindowFrameBounds :: PgSyntax

Instances

IsSql2003WindowFrameBoundsSyntax PgWindowFrameBoundsSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Sql2003WindowFrameBoundsBoundSyntax PgWindowFrameBoundsSyntax :: Type # Methods fromToBoundSyntax :: Sql2003WindowFrameBoundsBoundSyntax PgWindowFrameBoundsSyntax -> Maybe (Sql2003WindowFrameBoundsBoundSyntax PgWindowFrameBoundsSyntax) -> PgWindowFrameBoundsSyntax #
type Sql2003WindowFrameBoundsBoundSyntax PgWindowFrameBoundsSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Sql2003WindowFrameBoundsBoundSyntax PgWindowFrameBoundsSyntax = PgWindowFrameBoundSyntax

newtype PgWindowFrameBoundSyntax Source #

Constructors

PgWindowFrameBoundSyntax
Fields fromPgWindowFrameBound :: ByteString -> PgSyntax

Instances

IsSql2003WindowFrameBoundSyntax PgWindowFrameBoundSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods unboundedSyntax :: PgWindowFrameBoundSyntax # nrowsBoundSyntax :: Int -> PgWindowFrameBoundSyntax #

data PgSelectLockingClauseSyntax Source #

Constructors

PgSelectLockingClauseSyntax
Fields pgSelectLockingClauseStrength :: PgSelectLockingStrength pgSelectLockingTables :: [Text] pgSelectLockingClauseOptions :: Maybe PgSelectLockingOptions

data PgSelectLockingStrength Source #

Specifies the level of lock that will be taken against a row. See the manual section for more information.

Constructors

PgSelectLockingStrengthUpdate	UPDATE
PgSelectLockingStrengthNoKeyUpdate	NO KEY UPDATE
PgSelectLockingStrengthShare	SHARE
PgSelectLockingStrengthKeyShare	KEY SHARE

Instances

Eq PgSelectLockingStrength Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods (==) :: PgSelectLockingStrength -> PgSelectLockingStrength -> Bool # (/=) :: PgSelectLockingStrength -> PgSelectLockingStrength -> Bool #
Show PgSelectLockingStrength Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods showsPrec :: Int -> PgSelectLockingStrength -> ShowS # show :: PgSelectLockingStrength -> String # showList :: [PgSelectLockingStrength] -> ShowS #
Generic PgSelectLockingStrength Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Rep PgSelectLockingStrength :: Type -> Type # Methods from :: PgSelectLockingStrength -> Rep PgSelectLockingStrength x # to :: Rep PgSelectLockingStrength x -> PgSelectLockingStrength #
type Rep PgSelectLockingStrength Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Rep PgSelectLockingStrength = D1 (MetaData "PgSelectLockingStrength" "Database.Beam.Postgres.Syntax" "beam-postgres-0.4.0.0-GWUsEUf8XCGGrNini254Hd" False) ((C1 (MetaCons "PgSelectLockingStrengthUpdate" PrefixI False) (U1 :: Type -> Type) :+: C1 (MetaCons "PgSelectLockingStrengthNoKeyUpdate" PrefixI False) (U1 :: Type -> Type)) :+: (C1 (MetaCons "PgSelectLockingStrengthShare" PrefixI False) (U1 :: Type -> Type) :+: C1 (MetaCons "PgSelectLockingStrengthKeyShare" PrefixI False) (U1 :: Type -> Type)))

data PgSelectLockingOptions Source #

Specifies how we should handle lock conflicts.

See the manual section for more information

Constructors

PgSelectLockingOptionsNoWait	`NOWAIT`. Report an error rather than waiting for the lock
PgSelectLockingOptionsSkipLocked	`SKIP LOCKED`. Rather than wait for a lock, skip the row instead

Instances

Eq PgSelectLockingOptions Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods (==) :: PgSelectLockingOptions -> PgSelectLockingOptions -> Bool # (/=) :: PgSelectLockingOptions -> PgSelectLockingOptions -> Bool #
Show PgSelectLockingOptions Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods showsPrec :: Int -> PgSelectLockingOptions -> ShowS # show :: PgSelectLockingOptions -> String # showList :: [PgSelectLockingOptions] -> ShowS #
Generic PgSelectLockingOptions Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Rep PgSelectLockingOptions :: Type -> Type # Methods from :: PgSelectLockingOptions -> Rep PgSelectLockingOptions x # to :: Rep PgSelectLockingOptions x -> PgSelectLockingOptions #
type Rep PgSelectLockingOptions Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Rep PgSelectLockingOptions = D1 (MetaData "PgSelectLockingOptions" "Database.Beam.Postgres.Syntax" "beam-postgres-0.4.0.0-GWUsEUf8XCGGrNini254Hd" False) (C1 (MetaCons "PgSelectLockingOptionsNoWait" PrefixI False) (U1 :: Type -> Type) :+: C1 (MetaCons "PgSelectLockingOptionsSkipLocked" PrefixI False) (U1 :: Type -> Type))

fromPgSelectLockingClause :: PgSelectLockingClauseSyntax -> PgSyntax Source #

pgSelectStmt Source #

Arguments

:: PgSelectTableSyntax
-> [PgOrderingSyntax]
-> Maybe Integer	LIMIT
-> Maybe Integer	OFFSET
-> Maybe PgSelectLockingClauseSyntax
-> PgSelectSyntax

defaultPgValueSyntax :: ToField a => a -> PgValueSyntax Source #

data PgDataTypeDescr Source #

Constructors

PgDataTypeDescrOid Oid (Maybe Int32)
PgDataTypeDescrDomain Text

Instances

Eq PgDataTypeDescr Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods (==) :: PgDataTypeDescr -> PgDataTypeDescr -> Bool # (/=) :: PgDataTypeDescr -> PgDataTypeDescr -> Bool #
Show PgDataTypeDescr Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods showsPrec :: Int -> PgDataTypeDescr -> ShowS # show :: PgDataTypeDescr -> String # showList :: [PgDataTypeDescr] -> ShowS #
Generic PgDataTypeDescr Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Rep PgDataTypeDescr :: Type -> Type # Methods from :: PgDataTypeDescr -> Rep PgDataTypeDescr x # to :: Rep PgDataTypeDescr x -> PgDataTypeDescr #
Hashable PgDataTypeDescr Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods hashWithSalt :: Int -> PgDataTypeDescr -> Int # hash :: PgDataTypeDescr -> Int #
type Rep PgDataTypeDescr Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Rep PgDataTypeDescr = D1 (MetaData "PgDataTypeDescr" "Database.Beam.Postgres.Syntax" "beam-postgres-0.4.0.0-GWUsEUf8XCGGrNini254Hd" False) (C1 (MetaCons "PgDataTypeDescrOid" PrefixI False) (S1 (MetaSel (Nothing :: Maybe Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 Oid) :*: S1 (MetaSel (Nothing :: Maybe Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe Int32))) :+: C1 (MetaCons "PgDataTypeDescrDomain" PrefixI False) (S1 (MetaSel (Nothing :: Maybe Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 Text)))

data PgHasEnum Source #

Constructors

PgHasEnum Text [Text]

Instances

Eq PgHasEnum Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods (==) :: PgHasEnum -> PgHasEnum -> Bool # (/=) :: PgHasEnum -> PgHasEnum -> Bool #
Show PgHasEnum Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods showsPrec :: Int -> PgHasEnum -> ShowS # show :: PgHasEnum -> String # showList :: [PgHasEnum] -> ShowS #
Generic PgHasEnum Source #
Instance details Defined in Database.Beam.Postgres.Syntax Associated Types type Rep PgHasEnum :: Type -> Type # Methods from :: PgHasEnum -> Rep PgHasEnum x # to :: Rep PgHasEnum x -> PgHasEnum #
Hashable PgHasEnum Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods hashWithSalt :: Int -> PgHasEnum -> Int # hash :: PgHasEnum -> Int #
DatabasePredicate PgHasEnum Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods englishDescription :: PgHasEnum -> String # predicateSpecificity :: proxy PgHasEnum -> PredicateSpecificity # serializePredicate :: PgHasEnum -> Value # predicateCascadesDropOn :: DatabasePredicate p' => PgHasEnum -> p' -> Bool #
type Rep PgHasEnum Source #
Instance details Defined in Database.Beam.Postgres.Syntax type Rep PgHasEnum = D1 (MetaData "PgHasEnum" "Database.Beam.Postgres.Syntax" "beam-postgres-0.4.0.0-GWUsEUf8XCGGrNini254Hd" False) (C1 (MetaCons "PgHasEnum" PrefixI False) (S1 (MetaSel (Nothing :: Maybe Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 Text) :*: S1 (MetaSel (Nothing :: Maybe Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 [Text])))

pgCreateExtensionSyntax :: Text -> PgCommandSyntax Source #

pgDropExtensionSyntax :: Text -> PgCommandSyntax Source #

pgCreateEnumSyntax :: Text -> [PgValueSyntax] -> PgCommandSyntax Source #

pgDropTypeSyntax :: Text -> PgCommandSyntax Source #

pgSimpleMatchSyntax :: PgMatchTypeSyntax Source #

pgSelectSetQuantifierDistinctOn :: [PgExpressionSyntax] -> PgSelectSetQuantifierSyntax Source #

pgDataTypeJSON :: Value -> BeamSerializedDataType Source #

pgTsQueryType :: PgDataTypeSyntax Source #

pgTsVectorType :: PgDataTypeSyntax Source #

pgJsonType :: PgDataTypeSyntax Source #

pgJsonbType :: PgDataTypeSyntax Source #

pgUuidType :: PgDataTypeSyntax Source #

pgMoneyType :: PgDataTypeSyntax Source #

pgTsQueryTypeInfo :: TypeInfo Source #

pgTsVectorTypeInfo :: TypeInfo Source #

Postgres TypeInfo for tsvector TODO Is the Oid stable from postgres instance to postgres instance?

pgByteaType :: PgDataTypeSyntax Source #

pgTextType :: PgDataTypeSyntax Source #

pgUnboundedArrayType :: PgDataTypeSyntax -> PgDataTypeSyntax Source #

pgSerialType :: PgDataTypeSyntax Source #

pgSmallSerialType :: PgDataTypeSyntax Source #

pgBigSerialType :: PgDataTypeSyntax Source #

pgPointType :: PgDataTypeSyntax Source #

pgLineType :: PgDataTypeSyntax Source #

pgLineSegmentType :: PgDataTypeSyntax Source #

pgBoxType :: PgDataTypeSyntax Source #

pgQuotedIdentifier :: Text -> PgSyntax Source #

pgSepBy :: PgSyntax -> [PgSyntax] -> PgSyntax Source #

pgDebugRenderSyntax :: PgSyntax -> IO () Source #

pgRenderSyntaxScript :: PgSyntax -> ByteString Source #

pgBuildAction :: [Action] -> PgSyntax Source #

pgBinOp :: ByteString -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax Source #

pgCompOp :: ByteString -> Maybe PgComparisonQuantifierSyntax -> PgExpressionSyntax -> PgExpressionSyntax -> PgExpressionSyntax Source #

pgUnOp :: ByteString -> PgExpressionSyntax -> PgExpressionSyntax Source #

pgPostFix :: ByteString -> PgExpressionSyntax -> PgExpressionSyntax Source #

pgTestSyntax :: PgSyntax -> [PgSyntaxPrim] Source #

data PostgresInaccessible Source #

PgReferentialActionSyntax
Fields fromPgReferentialAction :: PgSyntax pgReferentialActionSerialized :: BeamSerializedReferentialAction

IsSql92ReferentialActionSyntax PgReferentialActionSyntax Source #
Instance details Defined in Database.Beam.Postgres.Syntax Methods referentialActionCascadeSyntax :: PgReferentialActionSyntax # referentialActionSetNullSyntax :: PgReferentialActionSyntax # referentialActionSetDefaultSyntax :: PgReferentialActionSyntax # referentialActionNoActionSyntax :: PgReferentialActionSyntax #