Opaleye.SqlTypes

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

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)

class IsSqlType sqlType

Minimal complete definition

showSqlType

Instances

IsSqlType SqlJsonb

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlJsonb -> String

IsSqlType SqlJson

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlJson -> String

IsSqlType SqlBytea

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlBytea -> String

IsSqlType SqlCitext

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlCitext -> String

IsSqlType SqlUuid

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlUuid -> String

IsSqlType SqlTimestamptz

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTimestamptz -> String

IsSqlType SqlTimestamp

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTimestamp -> String

IsSqlType SqlTime

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTime -> String

IsSqlType SqlText

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlText -> String

IsSqlType SqlNumeric

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlNumeric -> String

IsSqlType SqlInt2

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt2 -> String

IsSqlType SqlInt4

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt4 -> String

IsSqlType SqlInt8

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt8 -> String

IsSqlType SqlFloat8

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlFloat8 -> String

IsSqlType SqlFloat4

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlFloat4 -> String

IsSqlType SqlDate

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlDate -> String

IsSqlType SqlBool

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlBool -> String

IsSqlType a => IsSqlType (Nullable a)

Defined in Opaleye.Internal.PGTypes

Methods

showSqlType :: proxy (Nullable a) -> String

IsRangeType a => IsSqlType (SqlRange a)

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlRange a) -> String

IsSqlType a => IsSqlType (SqlArray a)

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlArray a) -> String

class IsSqlType pgType => IsRangeType pgType

Minimal complete definition

showRangeType

Instances

IsRangeType SqlTimestamptz

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlTimestamptz -> String

IsRangeType SqlTimestamp

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlTimestamp -> String

IsRangeType SqlNumeric

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlNumeric -> String

IsRangeType SqlInt4

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlInt4 -> String

IsRangeType SqlInt8

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlInt8 -> String

IsRangeType SqlDate

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlDate -> String

data SqlBool

Instances

IsSqlType SqlBool

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlBool -> String

SqlOrd SqlBool

Defined in Opaleye.Order

DefaultFromField SqlBool Bool

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlBool Bool

defaultFromField :: FromField SqlBool Bool

Default ToFields Bool (Column SqlBool)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Bool (Column SqlBool)

bool ~ Bool => Default (Inferrable FromField) SqlBool bool

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlBool bool

type Map Nulled (Column PGBool)

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGBool) = Column (Nullable PGBool)

data SqlDate

Instances

IsSqlType SqlDate

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlDate -> String

IsRangeType SqlDate

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlDate -> String

SqlOrd SqlDate

Defined in Opaleye.Order

DefaultFromField SqlDate Day

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlDate Day

defaultFromField :: FromField SqlDate Day

Default ToFields Day (Column SqlDate)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Day (Column SqlDate)

Default ToFields (PGRange Day) (Column (SqlRange SqlDate))

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange Day) (Column (SqlRange SqlDate))

day ~ Day => Default (Inferrable FromField) SqlDate day

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlDate day

type Map Nulled (Column PGDate)

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGDate) = Column (Nullable PGDate)

data SqlFloat4

Instances

IsSqlType SqlFloat4

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlFloat4 -> String

SqlOrd SqlFloat4

Defined in Opaleye.Order

data SqlFloat8

Instances

SqlFractional SqlFloat8

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromRational :: Rational -> Column SqlFloat8

sqlFromRational :: Rational -> Column SqlFloat8

SqlNum SqlFloat8

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromInteger :: Integer -> Column SqlFloat8

sqlFromInteger :: Integer -> Column SqlFloat8

IsSqlType SqlFloat8

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlFloat8 -> String

SqlOrd SqlFloat8

Defined in Opaleye.Order

DefaultFromField SqlFloat8 Double

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlFloat8 Double

defaultFromField :: FromField SqlFloat8 Double

Default ToFields Double (Column SqlFloat8)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Double (Column SqlFloat8)

double ~ Double => Default (Inferrable FromField) SqlFloat8 double

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlFloat8 double

type Map Nulled (Column PGFloat8)

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGFloat8) = Column (Nullable PGFloat8)

data SqlInt8

Instances

SqlIntegral SqlInt8

Defined in Opaleye.Internal.PGTypesExternal

SqlNum SqlInt8

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromInteger :: Integer -> Column SqlInt8

sqlFromInteger :: Integer -> Column SqlInt8

IsSqlType SqlInt8

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt8 -> String

IsRangeType SqlInt8

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlInt8 -> String

SqlOrd SqlInt8

Defined in Opaleye.Order

SqlJsonIndex SqlInt8

Defined in Opaleye.Operators

DefaultFromField SqlInt8 Int64

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlInt8 Int64

defaultFromField :: FromField SqlInt8 Int64

Default ToFields Int64 (Column SqlInt8)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Int64 (Column SqlInt8)

Default ToFields (PGRange Int64) (Column (SqlRange SqlInt8))

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange Int64) (Column (SqlRange SqlInt8))

int64 ~ Int64 => Default (Inferrable FromField) SqlInt8 int64

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlInt8 int64

type Map Nulled (Column PGInt8)

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGInt8) = Column (Nullable PGInt8)

data SqlInt4

Instances

SqlIntegral SqlInt4

Defined in Opaleye.Internal.PGTypesExternal

SqlNum SqlInt4

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromInteger :: Integer -> Column SqlInt4

sqlFromInteger :: Integer -> Column SqlInt4

IsSqlType SqlInt4

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt4 -> String

IsRangeType SqlInt4

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlInt4 -> String

SqlOrd SqlInt4

Defined in Opaleye.Order

SqlJsonIndex SqlInt4

Defined in Opaleye.Operators

DefaultFromField SqlInt4 Int

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlInt4 Int

defaultFromField :: FromField SqlInt4 Int

DefaultFromField SqlInt4 Int32

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlInt4 Int32

defaultFromField :: FromField SqlInt4 Int32

Default ToFields Int (Column SqlInt4)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Int (Column SqlInt4)

Default ToFields Int32 (Column SqlInt4)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Int32 (Column SqlInt4)

Default ToFields (PGRange Int) (Column (SqlRange SqlInt4))

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange Int) (Column (SqlRange SqlInt4))

int ~ Int => Default (Inferrable FromField) SqlInt4 int

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlInt4 int

type Map Nulled (Column PGInt4)

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGInt4) = Column (Nullable PGInt4)

data SqlInt2

Instances

SqlIntegral SqlInt2

Defined in Opaleye.Internal.PGTypesExternal

IsSqlType SqlInt2

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt2 -> String

SqlOrd SqlInt2

Defined in Opaleye.Order

data SqlNumeric

Instances

SqlIntegral SqlNumeric

Defined in Opaleye.Internal.PGTypesExternal

IsSqlType SqlNumeric

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlNumeric -> String

IsRangeType SqlNumeric

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlNumeric -> String

SqlOrd SqlNumeric

Defined in Opaleye.Order

DefaultFromField SqlNumeric Scientific

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlNumeric Scientific

defaultFromField :: FromField SqlNumeric Scientific

Default ToFields Scientific (Column SqlNumeric)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Scientific (Column SqlNumeric)

Default ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric))

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric))

scientific ~ Scientific => Default (Inferrable FromField) SqlNumeric scientific

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlNumeric scientific

data SqlText

Instances

SqlString SqlText

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromString :: String -> Column SqlText

sqlFromString :: String -> Column SqlText

IsSqlType SqlText

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlText -> String

SqlOrd SqlText

Defined in Opaleye.Order

SqlJsonIndex SqlText

Defined in Opaleye.Operators

DefaultFromField SqlText Text

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlText Text

defaultFromField :: FromField SqlText Text

DefaultFromField SqlText Text

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlText Text

defaultFromField :: FromField SqlText Text

DefaultFromField SqlText String

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlText String

defaultFromField :: FromField SqlText String

Default ToFields Text (Column SqlText)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Text (Column SqlText)

Default ToFields Text (Column SqlText)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Text (Column SqlText)

Default ToFields String (Column SqlText)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields String (Column SqlText)

text ~ Text => Default (Inferrable FromField) SqlText text

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlText text

type Map Nulled (Column PGText)

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGText) = Column (Nullable PGText)

type Map Nulled (Column PGText)

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGText) = Column (Nullable PGText)

data SqlTime

Instances

IsSqlType SqlTime

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTime -> String

SqlOrd SqlTime

Defined in Opaleye.Order

DefaultFromField SqlTime TimeOfDay

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlTime TimeOfDay

defaultFromField :: FromField SqlTime TimeOfDay

Default ToFields TimeOfDay (Column SqlTime)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields TimeOfDay (Column SqlTime)

timeofday ~ TimeOfDay => Default (Inferrable FromField) SqlTime timeofday

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlTime timeofday

type Map Nulled (Column PGTime)

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGTime) = Column (Nullable PGTime)

data SqlTimestamp

Instances

IsSqlType SqlTimestamp

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTimestamp -> String

IsRangeType SqlTimestamp

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlTimestamp -> String

SqlOrd SqlTimestamp

Defined in Opaleye.Order

DefaultFromField SqlTimestamp LocalTime

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlTimestamp LocalTime

defaultFromField :: FromField SqlTimestamp LocalTime

Default ToFields LocalTime (Column SqlTimestamp)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields LocalTime (Column SqlTimestamp)

Default ToFields (PGRange LocalTime) (Column (SqlRange SqlTimestamp))

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange LocalTime) (Column (SqlRange SqlTimestamp))

localtime ~ LocalTime => Default (Inferrable FromField) SqlTimestamp localtime

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlTimestamp localtime

type Map Nulled (Column PGTimestamp)

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGTimestamp) = Column (Nullable PGTimestamp)

data SqlTimestamptz

Instances

IsSqlType SqlTimestamptz

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTimestamptz -> String

IsRangeType SqlTimestamptz

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlTimestamptz -> String

SqlOrd SqlTimestamptz

Defined in Opaleye.Order

DefaultFromField SqlTimestamptz UTCTime

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlTimestamptz UTCTime

defaultFromField :: FromField SqlTimestamptz UTCTime

DefaultFromField SqlTimestamptz ZonedTime

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlTimestamptz ZonedTime

defaultFromField :: FromField SqlTimestamptz ZonedTime

Default ToFields UTCTime (Column SqlTimestamptz)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields UTCTime (Column SqlTimestamptz)

Default ToFields ZonedTime (Column SqlTimestamptz)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ZonedTime (Column SqlTimestamptz)

Default ToFields (PGRange UTCTime) (Column (SqlRange SqlTimestamptz))

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange UTCTime) (Column (SqlRange SqlTimestamptz))

type Map Nulled (Column PGTimestamptz)

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGTimestamptz) = Column (Nullable PGTimestamptz)

data SqlUuid

Instances

IsSqlType SqlUuid

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlUuid -> String

SqlOrd SqlUuid

Defined in Opaleye.Order

DefaultFromField SqlUuid UUID

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlUuid UUID

defaultFromField :: FromField SqlUuid UUID

Default ToFields UUID (Column SqlUuid)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields UUID (Column SqlUuid)

uuid ~ UUID => Default (Inferrable FromField) SqlUuid uuid

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlUuid uuid

type Map Nulled (Column PGUuid)

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGUuid) = Column (Nullable PGUuid)

data SqlCitext

Instances

SqlString SqlCitext

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromString :: String -> Column SqlCitext

sqlFromString :: String -> Column SqlCitext

IsSqlType SqlCitext

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlCitext -> String

SqlOrd SqlCitext

Defined in Opaleye.Order

DefaultFromField SqlCitext (CI Text)

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlCitext (CI Text)

defaultFromField :: FromField SqlCitext (CI Text)

DefaultFromField SqlCitext (CI Text)

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlCitext (CI Text)

defaultFromField :: FromField SqlCitext (CI Text)

Default ToFields (CI Text) (Column SqlCitext)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (CI Text) (Column SqlCitext)

Default ToFields (CI Text) (Column SqlCitext)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (CI Text) (Column SqlCitext)

cttext ~ CI Text => Default (Inferrable FromField) SqlCitext cttext

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlCitext cttext

type Map Nulled (Column PGCitext)

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGCitext) = Column (Nullable PGCitext)

data SqlArray a

Instances

(Default ToFields a (Column b), IsSqlType b) => Default ToFields [a] (Column (SqlArray b))

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields [a] (Column (SqlArray b))

IsSqlType a => IsSqlType (SqlArray a)

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlArray a) -> String

(Typeable b, DefaultFromField a b) => DefaultFromField (SqlArray a) [b]

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField (SqlArray a) [b]

defaultFromField :: FromField (SqlArray a) [b]

(Typeable h, Default (Inferrable FromField) f h, hs ~ [h]) => Default (Inferrable FromField) (SqlArray f) hs

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField (SqlArray f) hs

data SqlBytea

Instances

IsSqlType SqlBytea

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlBytea -> String

DefaultFromField SqlBytea ByteString

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlBytea ByteString

defaultFromField :: FromField SqlBytea ByteString

DefaultFromField SqlBytea ByteString

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlBytea ByteString

defaultFromField :: FromField SqlBytea ByteString

Default ToFields ByteString (Column SqlBytea)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlBytea)

Default ToFields ByteString (Column SqlBytea)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlBytea)

bytestring ~ ByteString => Default (Inferrable FromField) SqlBytea bytestring

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlBytea bytestring

type Map Nulled (Column PGBytea)

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGBytea) = Column (Nullable PGBytea)

data SqlJson

Instances

IsSqlType SqlJson

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlJson -> String

SqlIsJson SqlJson

Defined in Opaleye.Operators

DefaultFromField SqlJson Value

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJson Value

defaultFromField :: FromField SqlJson Value

DefaultFromField SqlJson String

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJson String

defaultFromField :: FromField SqlJson String

Default ToFields ByteString (Column SqlJson)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlJson)

Default ToFields ByteString (Column SqlJson)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlJson)

Default ToFields Value (Column SqlJson)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Value (Column SqlJson)

type Map Nulled (Column PGJson)

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGJson) = Column (Nullable PGJson)

data SqlJsonb

Instances

IsSqlType SqlJsonb

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlJsonb -> String

SqlIsJson SqlJsonb

Defined in Opaleye.Operators

DefaultFromField SqlJsonb Value

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJsonb Value

defaultFromField :: FromField SqlJsonb Value

DefaultFromField SqlJsonb String

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJsonb String

defaultFromField :: FromField SqlJsonb String

Default ToFields ByteString (Column SqlJsonb)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlJsonb)

Default ToFields ByteString (Column SqlJsonb)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlJsonb)

Default ToFields Value (Column SqlJsonb)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Value (Column SqlJsonb)

type Map Nulled (Column PGJsonb)

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGJsonb) = Column (Nullable PGJsonb)

data SqlRange a

Instances

Default ToFields (PGRange Int) (Column (SqlRange SqlInt4))

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange Int) (Column (SqlRange SqlInt4))

Default ToFields (PGRange Int64) (Column (SqlRange SqlInt8))

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange Int64) (Column (SqlRange SqlInt8))

Default ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric))

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric))

Default ToFields (PGRange UTCTime) (Column (SqlRange SqlTimestamptz))

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange UTCTime) (Column (SqlRange SqlTimestamptz))

Default ToFields (PGRange LocalTime) (Column (SqlRange SqlTimestamp))

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange LocalTime) (Column (SqlRange SqlTimestamp))

Default ToFields (PGRange Day) (Column (SqlRange SqlDate))

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange Day) (Column (SqlRange SqlDate))

IsRangeType a => IsSqlType (SqlRange a)

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlRange a) -> String

(Typeable b, FromField b, DefaultFromField a b) => DefaultFromField (PGRange a) (PGRange b)

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField (PGRange a) (PGRange0 b)

defaultFromField :: FromField (PGRange a) (PGRange0 b)