opaleye-0.6.7005.0: An SQL-generating DSL targeting PostgreSQL

Safe HaskellNone
LanguageHaskell2010

Opaleye.SqlTypes

Description

SQL types and functions to create Field_s of those types. To create fields you may find it more convenient to use Opaleye.ToFields instead.

Documentation

type SqlRange = PGRange Source #

type SqlJsonb = PGJsonb Source #

type SqlJson = PGJson Source #

type SqlBytea = PGBytea Source #

type SqlArray = PGArray Source #

type SqlCitext = PGCitext Source #

type SqlUuid = PGUuid Source #

type SqlTimestamptz = PGTimestamptz Source #

type SqlTimestamp = PGTimestamp Source #

type SqlTime = PGTime Source #

type SqlText = PGText Source #

type SqlNumeric = PGNumeric Source #

type SqlInt2 = PGInt2 Source #

type SqlInt4 = PGInt4 Source #

type SqlInt8 = PGInt8 Source #

type SqlFloat8 = PGFloat8 Source #

type SqlFloat4 = PGFloat4 Source #

type SqlDate = PGDate Source #

type SqlBool = PGBool Source #

sqlString :: String -> Field SqlText Source #

sqlLazyByteString :: ByteString -> Field SqlBytea Source #

sqlStrictByteString :: ByteString -> Field SqlBytea Source #

sqlStrictText :: Text -> Field SqlText Source #

sqlLazyText :: Text -> Field SqlText Source #

sqlNumeric :: Scientific -> Field SqlNumeric Source #

sqlInt4 :: Int -> Field SqlInt4 Source #

sqlInt8 :: Int64 -> Field SqlInt8 Source #

sqlDouble :: Double -> Field SqlFloat8 Source #

sqlBool :: Bool -> Field SqlBool Source #

sqlUUID :: UUID -> Field SqlUuid Source #

sqlDay :: Day -> Field SqlDate Source #

sqlUTCTime :: UTCTime -> Field SqlTimestamptz Source #

sqlLocalTime :: LocalTime -> Field SqlTimestamp Source #

sqlZonedTime :: ZonedTime -> Field SqlTimestamptz Source #

sqlTimeOfDay :: TimeOfDay -> Field SqlTime Source #

sqlCiStrictText :: CI Text -> Field SqlCitext Source #

sqlCiLazyText :: CI Text -> Field SqlCitext Source #

sqlJSON :: String -> Field SqlJson Source #

sqlStrictJSON :: ByteString -> Field SqlJson Source #

sqlLazyJSON :: ByteString -> Field SqlJson Source #

sqlValueJSON :: ToJSON a => a -> Field SqlJson Source #

sqlJSONB :: String -> Field SqlJsonb Source #

sqlStrictJSONB :: ByteString -> Field SqlJsonb Source #

sqlLazyJSONB :: ByteString -> Field SqlJsonb Source #

sqlValueJSONB :: ToJSON a => a -> Field SqlJsonb Source #

sqlArray :: IsSqlType b => (a -> Field b) -> [a] -> Field (SqlArray b) Source #

sqlRange :: IsRangeType b => (a -> Field b) -> RangeBound a -> RangeBound a -> Field (SqlRange b) Source #

class IsSqlType sqlType Source #

Minimal complete definition

showPGType | showSqlType

Instances
IsSqlType PGJsonb Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGJsonb -> String Source #

showSqlType :: proxy PGJsonb -> String Source #

IsSqlType PGJson Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGJson -> String Source #

showSqlType :: proxy PGJson -> String Source #

IsSqlType PGBytea Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGBytea -> String Source #

showSqlType :: proxy PGBytea -> String Source #

IsSqlType PGCitext Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGCitext -> String Source #

showSqlType :: proxy PGCitext -> String Source #

IsSqlType PGUuid Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGUuid -> String Source #

showSqlType :: proxy PGUuid -> String Source #

IsSqlType PGTimestamptz Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGTimestamptz -> String Source #

showSqlType :: proxy PGTimestamptz -> String Source #

IsSqlType PGTimestamp Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGTimestamp -> String Source #

showSqlType :: proxy PGTimestamp -> String Source #

IsSqlType PGTime Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGTime -> String Source #

showSqlType :: proxy PGTime -> String Source #

IsSqlType PGText Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGText -> String Source #

showSqlType :: proxy PGText -> String Source #

IsSqlType PGNumeric Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGNumeric -> String Source #

showSqlType :: proxy PGNumeric -> String Source #

IsSqlType PGInt2 Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGInt2 -> String Source #

showSqlType :: proxy PGInt2 -> String Source #

IsSqlType PGInt4 Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGInt4 -> String Source #

showSqlType :: proxy PGInt4 -> String Source #

IsSqlType PGInt8 Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGInt8 -> String Source #

showSqlType :: proxy PGInt8 -> String Source #

IsSqlType PGFloat8 Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGFloat8 -> String Source #

showSqlType :: proxy PGFloat8 -> String Source #

IsSqlType PGFloat4 Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGFloat4 -> String Source #

showSqlType :: proxy PGFloat4 -> String Source #

IsSqlType PGDate Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGDate -> String Source #

showSqlType :: proxy PGDate -> String Source #

IsSqlType PGBool Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showPGType :: proxy PGBool -> String Source #

showSqlType :: proxy PGBool -> String Source #

IsSqlType a => IsSqlType (Nullable a) Source # 
Instance details

Defined in Opaleye.Internal.PGTypes

Methods

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

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

IsRangeType a => IsSqlType (PGRange a) Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

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

showSqlType :: proxy (PGRange a) -> String Source #

IsSqlType a => IsSqlType (PGArray a) Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

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

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

class IsSqlType pgType => IsRangeType pgType Source #

Minimal complete definition

showRangeType

Instances
IsRangeType PGTimestamptz Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showRangeType :: proxy PGTimestamptz -> String Source #

IsRangeType PGTimestamp Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showRangeType :: proxy PGTimestamp -> String Source #

IsRangeType PGNumeric Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showRangeType :: proxy PGNumeric -> String Source #

IsRangeType PGInt4 Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showRangeType :: proxy PGInt4 -> String Source #

IsRangeType PGInt8 Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showRangeType :: proxy PGInt8 -> String Source #

IsRangeType PGDate Source # 
Instance details

Defined in Opaleye.PGTypes

Methods

showRangeType :: proxy PGDate -> String Source #