Opaleye.SqlTypes

Creating SQL values

sqlString :: String -> Field SqlText

sqlLazyByteString :: ByteString -> Field SqlBytea

sqlStrictByteString :: ByteString -> Field SqlBytea

sqlStrictText :: Text -> Field SqlText

sqlLazyText :: Text -> Field SqlText

sqlNumeric :: Scientific -> Field SqlNumeric

sqlInt4 :: Int -> Field SqlInt4

sqlInt8 :: Int64 -> Field SqlInt8

sqlDouble :: Double -> Field SqlFloat8

sqlBool :: Bool -> Field SqlBool

sqlUUID :: UUID -> Field SqlUuid

sqlDay :: Day -> Field SqlDate

sqlUTCTime :: UTCTime -> Field SqlTimestamptz

sqlLocalTime :: LocalTime -> Field SqlTimestamp

sqlZonedTime :: ZonedTime -> Field SqlTimestamptz

sqlTimeOfDay :: TimeOfDay -> Field SqlTime

sqlCiStrictText :: CI Text -> Field SqlCitext

sqlCiLazyText :: CI Text -> Field SqlCitext

sqlJSON :: String -> Field SqlJson

sqlStrictJSON :: ByteString -> Field SqlJson

sqlLazyJSON :: ByteString -> Field SqlJson

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

sqlJSONB :: String -> Field SqlJsonb

sqlStrictJSONB :: ByteString -> Field SqlJsonb

sqlLazyJSONB :: ByteString -> Field SqlJsonb

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

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

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

SQL datatypes

type SqlBool = PGBool

type SqlDate = PGDate

type SqlFloat4 = PGFloat4

type SqlFloat8 = PGFloat8

type SqlInt8 = PGInt8

type SqlInt4 = PGInt4

type SqlInt2 = PGInt2

type SqlNumeric = PGNumeric

type SqlText = PGText

type SqlTime = PGTime

type SqlTimestamp = PGTimestamp

type SqlTimestamptz = PGTimestamptz

type SqlUuid = PGUuid

type SqlCitext = PGCitext

type SqlArray = PGArray

type SqlBytea = PGBytea

type SqlJson = PGJson

type SqlJsonb = PGJsonb

type SqlRange = PGRange

class IsSqlType sqlType

Instances

IsSqlType PGJsonb

Methods

showPGType :: proxy PGJsonb -> String

showSqlType :: proxy PGJsonb -> String

IsSqlType PGJson

Methods

showPGType :: proxy PGJson -> String

showSqlType :: proxy PGJson -> String

IsSqlType PGBytea

Methods

showPGType :: proxy PGBytea -> String

showSqlType :: proxy PGBytea -> String

IsSqlType PGCitext

Methods

showPGType :: proxy PGCitext -> String

showSqlType :: proxy PGCitext -> String

IsSqlType PGUuid

Methods

showPGType :: proxy PGUuid -> String

showSqlType :: proxy PGUuid -> String

IsSqlType PGTimestamptz

Methods

showPGType :: proxy PGTimestamptz -> String

showSqlType :: proxy PGTimestamptz -> String

IsSqlType PGTimestamp

Methods

showPGType :: proxy PGTimestamp -> String

showSqlType :: proxy PGTimestamp -> String

IsSqlType PGTime

Methods

showPGType :: proxy PGTime -> String

showSqlType :: proxy PGTime -> String

IsSqlType PGText

Methods

showPGType :: proxy PGText -> String

showSqlType :: proxy PGText -> String

IsSqlType PGNumeric

Methods

showPGType :: proxy PGNumeric -> String

showSqlType :: proxy PGNumeric -> String

IsSqlType PGInt2

Methods

showPGType :: proxy PGInt2 -> String

showSqlType :: proxy PGInt2 -> String

IsSqlType PGInt4

Methods

showPGType :: proxy PGInt4 -> String

showSqlType :: proxy PGInt4 -> String

IsSqlType PGInt8

Methods

showPGType :: proxy PGInt8 -> String

showSqlType :: proxy PGInt8 -> String

IsSqlType PGFloat8

Methods

showPGType :: proxy PGFloat8 -> String

showSqlType :: proxy PGFloat8 -> String

IsSqlType PGFloat4

Methods

showPGType :: proxy PGFloat4 -> String

showSqlType :: proxy PGFloat4 -> String

IsSqlType PGDate

Methods

showPGType :: proxy PGDate -> String

showSqlType :: proxy PGDate -> String

IsSqlType PGBool

Methods

showPGType :: proxy PGBool -> String

showSqlType :: proxy PGBool -> String

IsSqlType a => IsSqlType (Nullable a)

Methods

showPGType :: proxy (Nullable a) -> String

showSqlType :: proxy (Nullable a) -> String

IsRangeType a => IsSqlType (PGRange a)

Methods

showPGType :: proxy (PGRange a) -> String

showSqlType :: proxy (PGRange a) -> String

IsSqlType a => IsSqlType (PGArray a)

Methods

showPGType :: proxy (PGArray a) -> String

showSqlType :: proxy (PGArray a) -> String

class IsSqlType pgType => IsRangeType pgType

Minimal complete definition

showRangeType

Instances

IsRangeType PGTimestamptz

Methods

showRangeType :: proxy PGTimestamptz -> String

IsRangeType PGTimestamp

Methods

showRangeType :: proxy PGTimestamp -> String

IsRangeType PGNumeric

Methods

showRangeType :: proxy PGNumeric -> String

IsRangeType PGInt4

Methods

showRangeType :: proxy PGInt4 -> String

IsRangeType PGInt8

Methods

showRangeType :: proxy PGInt8 -> String

IsRangeType PGDate

Methods

showRangeType :: proxy PGDate -> String