opaleye-0.5.2.2: An SQL-generating DSL targeting PostgreSQL

Safe HaskellNone
LanguageHaskell2010

Opaleye.PGTypes

Contents

Description

Postgres types and functions to create Columns of those types. You may find it more convenient to use Opaleye.Constant instead.

Synopsis

Documentation

Creating SQL values

pgArray :: forall a b. IsSqlType b => (a -> Column b) -> [a] -> Column (PGArray b) Source #

class IsSqlType pgType where Source #

Minimal complete definition

showPGType

Methods

showPGType :: proxy pgType -> String Source #

Instances

IsSqlType PGJsonb Source # 

Methods

showPGType :: proxy PGJsonb -> String Source #

IsSqlType PGJson Source # 

Methods

showPGType :: proxy PGJson -> String Source #

IsSqlType PGBytea Source # 

Methods

showPGType :: proxy PGBytea -> String Source #

IsSqlType PGCitext Source # 

Methods

showPGType :: proxy PGCitext -> String Source #

IsSqlType PGUuid Source # 

Methods

showPGType :: proxy PGUuid -> String Source #

IsSqlType PGTimestamptz Source # 
IsSqlType PGTimestamp Source # 

Methods

showPGType :: proxy PGTimestamp -> String Source #

IsSqlType PGTime Source # 

Methods

showPGType :: proxy PGTime -> String Source #

IsSqlType PGText Source # 

Methods

showPGType :: proxy PGText -> String Source #

IsSqlType PGNumeric Source # 

Methods

showPGType :: proxy PGNumeric -> String Source #

IsSqlType PGInt2 Source # 

Methods

showPGType :: proxy PGInt2 -> String Source #

IsSqlType PGInt4 Source # 

Methods

showPGType :: proxy PGInt4 -> String Source #

IsSqlType PGInt8 Source # 

Methods

showPGType :: proxy PGInt8 -> String Source #

IsSqlType PGFloat8 Source # 

Methods

showPGType :: proxy PGFloat8 -> String Source #

IsSqlType PGFloat4 Source # 

Methods

showPGType :: proxy PGFloat4 -> String Source #

IsSqlType PGDate Source # 

Methods

showPGType :: proxy PGDate -> String Source #

IsSqlType PGBool Source # 

Methods

showPGType :: proxy PGBool -> String Source #

IsSqlType a => IsSqlType (Nullable a) Source # 

Methods

showPGType :: proxy (Nullable a) -> String Source #

IsSqlType a => IsSqlType (PGArray a) Source # 

Methods

showPGType :: proxy (PGArray a) -> String Source #

SQL datatypes

Deprecated functions

literalColumn :: Literal -> Column a Source #

Warning: literalColumn has been moved to Opaleye.Internal.PGTypes and will be deprecated in version 0.6

unsafePgFormatTime :: FormatTime t => Name -> String -> t -> Column c Source #

Warning: unsafePgFormatTime has been moved to Opaleye.Internal.PGTypes and will be deprecated in version 0.6