Default ToFields (PGRange Int) (Column (SqlRange SqlInt4)) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields (PGRange Int) (Column (SqlRange SqlInt4)) #
Default ToFields (PGRange Int64) (Column (SqlRange SqlInt8)) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields (PGRange Int64) (Column (SqlRange SqlInt8)) #
Default ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric)) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric)) #
Default ToFields (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) #
Default ToFields (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) #
Default ToFields (PGRange Day) (Column (SqlRange SqlDate)) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields (PGRange Day) (Column (SqlRange SqlDate)) #
IsRangeType a => IsSqlType (SqlRange a) Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy (SqlRange a) -> String Source #
(Typeable b, DefaultFromField a b) => DefaultFromField (PGRange a) (PGRange b) Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField (PGRange a) (PGRange0 b) Source # defaultFromField :: FromField (PGRange a) (PGRange0 b) Source #

data SqlJsonb Source #

Instances

Instances details

IsSqlType SqlJsonb Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlJsonb -> String Source #
SqlIsJson SqlJsonb Source #
Instance details Defined in Opaleye.Operators
DefaultFromField SqlJsonb ByteString Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlJsonb ByteString Source # defaultFromField :: FromField SqlJsonb ByteString Source #
DefaultFromField SqlJsonb ByteString Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlJsonb ByteString Source # defaultFromField :: FromField SqlJsonb ByteString Source #
DefaultFromField SqlJsonb String Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlJsonb String Source # defaultFromField :: FromField SqlJsonb String Source #
DefaultFromField SqlJsonb Text Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlJsonb Text Source # defaultFromField :: FromField SqlJsonb Text Source #
DefaultFromField SqlJsonb Value Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlJsonb Value Source # defaultFromField :: FromField SqlJsonb Value Source #
DefaultFromField SqlJsonb Text Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlJsonb Text Source # defaultFromField :: FromField SqlJsonb Text Source #
Default ToFields ByteString (Column SqlJsonb) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields ByteString (Column SqlJsonb) #
Default ToFields ByteString (Column SqlJsonb) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields ByteString (Column SqlJsonb) #
Default ToFields Value (Column SqlJsonb) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields Value (Column SqlJsonb) #
type Map Nulled (Column PGJsonb) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGJsonb) = Column (Nullable PGJsonb)

data SqlJson Source #

Instances

Instances details

IsSqlType SqlJson Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlJson -> String Source #
SqlIsJson SqlJson Source #
Instance details Defined in Opaleye.Operators
DefaultFromField SqlJson ByteString Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlJson ByteString Source # defaultFromField :: FromField SqlJson ByteString Source #
DefaultFromField SqlJson ByteString Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlJson ByteString Source # defaultFromField :: FromField SqlJson ByteString Source #
DefaultFromField SqlJson String Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlJson String Source # defaultFromField :: FromField SqlJson String Source #
DefaultFromField SqlJson Text Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlJson Text Source # defaultFromField :: FromField SqlJson Text Source #
DefaultFromField SqlJson Value Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlJson Value Source # defaultFromField :: FromField SqlJson Value Source #
DefaultFromField SqlJson Text Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlJson Text Source # defaultFromField :: FromField SqlJson Text Source #
Default ToFields ByteString (Column SqlJson) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields ByteString (Column SqlJson) #
Default ToFields ByteString (Column SqlJson) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields ByteString (Column SqlJson) #
Default ToFields Value (Column SqlJson) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields Value (Column SqlJson) #
type Map Nulled (Column PGJson) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGJson) = Column (Nullable PGJson)

data SqlBytea Source #

Instances

Instances details

IsSqlType SqlBytea Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlBytea -> String Source #
DefaultFromField SqlBytea ByteString Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlBytea ByteString Source # defaultFromField :: FromField SqlBytea ByteString Source #
DefaultFromField SqlBytea ByteString Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlBytea ByteString Source # defaultFromField :: FromField SqlBytea ByteString Source #
Default ToFields ByteString (Column SqlBytea) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields ByteString (Column SqlBytea) #
Default ToFields ByteString (Column SqlBytea) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields ByteString (Column SqlBytea) #
bytestring ~ ByteString => Default (Inferrable FromField) SqlBytea bytestring Source #
Instance details Defined in Opaleye.Internal.Inferrable Methods def :: Inferrable FromField SqlBytea bytestring #
type Map Nulled (Column PGBytea) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGBytea) = Column (Nullable PGBytea)

data SqlArray a Source #

Instances

Instances details

(Default ToFields a (Column b), IsSqlType b) => Default ToFields [a] (Column (SqlArray b)) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields [a] (Column (SqlArray b)) #
IsSqlType a => IsSqlType (SqlArray a) Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy (SqlArray a) -> String Source #
(Typeable b, DefaultFromField a b) => DefaultFromField (SqlArray a) [b] Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField (SqlArray a) [b] Source # defaultFromField :: FromField (SqlArray a) [b] Source #
(Typeable h, Default (Inferrable FromField) f h, hs ~ [h]) => Default (Inferrable FromField) (SqlArray f) hs Source #
Instance details Defined in Opaleye.Internal.Inferrable Methods def :: Inferrable FromField (SqlArray f) hs #

data SqlCitext Source #

Instances

Instances details

SqlString SqlCitext Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods pgFromString :: String -> Column SqlCitext Source # sqlFromString :: String -> Column SqlCitext Source #
IsSqlType SqlCitext Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlCitext -> String Source #
SqlOrd SqlCitext Source #
Instance details Defined in Opaleye.Order
DefaultFromField SqlCitext (CI Text) Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlCitext (CI Text) Source # defaultFromField :: FromField SqlCitext (CI Text) Source #
DefaultFromField SqlCitext (CI Text) Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlCitext (CI Text) Source # defaultFromField :: FromField SqlCitext (CI Text) Source #
Default ToFields (CI Text) (Column SqlCitext) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields (CI Text) (Column SqlCitext) #
Default ToFields (CI Text) (Column SqlCitext) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields (CI Text) (Column SqlCitext) #
cttext ~ CI Text => Default (Inferrable FromField) SqlCitext cttext Source #
Instance details Defined in Opaleye.Internal.Inferrable Methods def :: Inferrable FromField SqlCitext cttext #
type Map Nulled (Column PGCitext) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGCitext) = Column (Nullable PGCitext)

data SqlUuid Source #

Instances

Instances details

IsSqlType SqlUuid Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlUuid -> String Source #
SqlOrd SqlUuid Source #
Instance details Defined in Opaleye.Order
DefaultFromField SqlUuid UUID Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlUuid UUID Source # defaultFromField :: FromField SqlUuid UUID Source #
Default ToFields UUID (Column SqlUuid) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields UUID (Column SqlUuid) #
uuid ~ UUID => Default (Inferrable FromField) SqlUuid uuid Source #
Instance details Defined in Opaleye.Internal.Inferrable Methods def :: Inferrable FromField SqlUuid uuid #
type Map Nulled (Column PGUuid) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGUuid) = Column (Nullable PGUuid)

data SqlTimestamptz Source #

Be careful if you use Haskell's ZonedTime with SqlTimestamptz. A Postgres timestamptz does not actually contain any time zone. It is just a UTC time that is automatically converted to or from local time on certain occasions, according to the timezone setting of the server. Therefore, although when you roundtrip an input ZonedTime to obtain an output ZonedTime they each refer to the same instant in time, the time zone attached to the output will not necessarily the same as the time zone attached to the input.

Instances

Instances details

IsSqlType SqlTimestamptz Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlTimestamptz -> String Source #
IsRangeType SqlTimestamptz Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showRangeType :: proxy SqlTimestamptz -> String Source #
SqlOrd SqlTimestamptz Source #
Instance details Defined in Opaleye.Order
DefaultFromField SqlTimestamptz UTCTime Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlTimestamptz UTCTime Source # defaultFromField :: FromField SqlTimestamptz UTCTime Source #
DefaultFromField SqlTimestamptz ZonedTime Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlTimestamptz ZonedTime Source # defaultFromField :: FromField SqlTimestamptz ZonedTime Source #
Default ToFields UTCTime (Column SqlTimestamptz) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields UTCTime (Column SqlTimestamptz) #
Default ToFields ZonedTime (Column SqlTimestamptz) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields ZonedTime (Column SqlTimestamptz) #
Default ToFields (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) #
type Map Nulled (Column PGTimestamptz) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGTimestamptz) = Column (Nullable PGTimestamptz)

data SqlTimestamp Source #

Instances

Instances details

IsSqlType SqlTimestamp Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlTimestamp -> String Source #
IsRangeType SqlTimestamp Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showRangeType :: proxy SqlTimestamp -> String Source #
SqlOrd SqlTimestamp Source #
Instance details Defined in Opaleye.Order
DefaultFromField SqlTimestamp LocalTime Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlTimestamp LocalTime Source # defaultFromField :: FromField SqlTimestamp LocalTime Source #
Default ToFields LocalTime (Column SqlTimestamp) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields LocalTime (Column SqlTimestamp) #
Default ToFields (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) #
localtime ~ LocalTime => Default (Inferrable FromField) SqlTimestamp localtime Source #
Instance details Defined in Opaleye.Internal.Inferrable Methods def :: Inferrable FromField SqlTimestamp localtime #
type Map Nulled (Column PGTimestamp) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGTimestamp) = Column (Nullable PGTimestamp)

data SqlTime Source #

Instances

Instances details

IsSqlType SqlTime Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlTime -> String Source #
SqlOrd SqlTime Source #
Instance details Defined in Opaleye.Order
DefaultFromField SqlTime TimeOfDay Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlTime TimeOfDay Source # defaultFromField :: FromField SqlTime TimeOfDay Source #
Default ToFields TimeOfDay (Column SqlTime) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields TimeOfDay (Column SqlTime) #
timeofday ~ TimeOfDay => Default (Inferrable FromField) SqlTime timeofday Source #
Instance details Defined in Opaleye.Internal.Inferrable Methods def :: Inferrable FromField SqlTime timeofday #
type Map Nulled (Column PGTime) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGTime) = Column (Nullable PGTime)

data SqlText Source #

Instances

Instances details

SqlString SqlText Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods pgFromString :: String -> Column SqlText Source # sqlFromString :: String -> Column SqlText Source #
IsSqlType SqlText Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlText -> String Source #
SqlOrd SqlText Source #
Instance details Defined in Opaleye.Order
SqlJsonIndex SqlText Source #
Instance details Defined in Opaleye.Operators
DefaultFromField SqlText String Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlText String Source # defaultFromField :: FromField SqlText String Source #
DefaultFromField SqlText Text Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlText Text Source # defaultFromField :: FromField SqlText Text Source #
DefaultFromField SqlText Text Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlText Text Source # defaultFromField :: FromField SqlText Text Source #
Default ToFields String (Column SqlText) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields String (Column SqlText) #
Default ToFields Text (Column SqlText) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields Text (Column SqlText) #
Default ToFields Text (Column SqlText) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields Text (Column SqlText) #
text ~ Text => Default (Inferrable FromField) SqlText text Source #
Instance details Defined in Opaleye.Internal.Inferrable Methods def :: Inferrable FromField SqlText text #
type Map Nulled (Column PGText) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGText) = Column (Nullable PGText)
type Map Nulled (Column PGText) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGText) = Column (Nullable PGText)

data SqlNumeric Source #

Instances

Instances details

SqlIntegral SqlNumeric Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal
SqlNum SqlNumeric Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods pgFromInteger :: Integer -> Column SqlNumeric Source # sqlFromInteger :: Integer -> Column SqlNumeric Source #
IsSqlType SqlNumeric Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlNumeric -> String Source #
IsRangeType SqlNumeric Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showRangeType :: proxy SqlNumeric -> String Source #
SqlOrd SqlNumeric Source #
Instance details Defined in Opaleye.Order
DefaultFromField SqlNumeric Scientific Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlNumeric Scientific Source # defaultFromField :: FromField SqlNumeric Scientific Source #
Default ToFields Scientific (Column SqlNumeric) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields Scientific (Column SqlNumeric) #
Default ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric)) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric)) #
scientific ~ Scientific => Default (Inferrable FromField) SqlNumeric scientific Source #
Instance details Defined in Opaleye.Internal.Inferrable Methods def :: Inferrable FromField SqlNumeric scientific #

data SqlInt2 Source #

Instances

Instances details

SqlIntegral SqlInt2 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal
IsSqlType SqlInt2 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlInt2 -> String Source #
SqlOrd SqlInt2 Source #
Instance details Defined in Opaleye.Order

data SqlInt4 Source #

Instances

Instances details

SqlIntegral SqlInt4 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal
SqlNum SqlInt4 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods pgFromInteger :: Integer -> Column SqlInt4 Source # sqlFromInteger :: Integer -> Column SqlInt4 Source #
IsSqlType SqlInt4 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlInt4 -> String Source #
IsRangeType SqlInt4 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showRangeType :: proxy SqlInt4 -> String Source #
SqlOrd SqlInt4 Source #
Instance details Defined in Opaleye.Order
SqlJsonIndex SqlInt4 Source #
Instance details Defined in Opaleye.Operators
DefaultFromField SqlInt4 Int Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlInt4 Int Source # defaultFromField :: FromField SqlInt4 Int Source #
DefaultFromField SqlInt4 Int32 Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlInt4 Int32 Source # defaultFromField :: FromField SqlInt4 Int32 Source #
Default ToFields Int (Column SqlInt4) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields Int (Column SqlInt4) #
Default ToFields Int32 (Column SqlInt4) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields Int32 (Column SqlInt4) #
Default ToFields (PGRange Int) (Column (SqlRange SqlInt4)) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields (PGRange Int) (Column (SqlRange SqlInt4)) #
int ~ Int => Default (Inferrable FromField) SqlInt4 int Source #
Instance details Defined in Opaleye.Internal.Inferrable Methods def :: Inferrable FromField SqlInt4 int #
type Map Nulled (Column PGInt4) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGInt4) = Column (Nullable PGInt4)

data SqlInt8 Source #

Instances

Instances details

SqlIntegral SqlInt8 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal
SqlNum SqlInt8 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods pgFromInteger :: Integer -> Column SqlInt8 Source # sqlFromInteger :: Integer -> Column SqlInt8 Source #
IsSqlType SqlInt8 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlInt8 -> String Source #
IsRangeType SqlInt8 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showRangeType :: proxy SqlInt8 -> String Source #
SqlOrd SqlInt8 Source #
Instance details Defined in Opaleye.Order
SqlJsonIndex SqlInt8 Source #
Instance details Defined in Opaleye.Operators
DefaultFromField SqlInt8 Int64 Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlInt8 Int64 Source # defaultFromField :: FromField SqlInt8 Int64 Source #
Default ToFields Int64 (Column SqlInt8) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields Int64 (Column SqlInt8) #
Default ToFields (PGRange Int64) (Column (SqlRange SqlInt8)) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields (PGRange Int64) (Column (SqlRange SqlInt8)) #
int64 ~ Int64 => Default (Inferrable FromField) SqlInt8 int64 Source #
Instance details Defined in Opaleye.Internal.Inferrable Methods def :: Inferrable FromField SqlInt8 int64 #
type Map Nulled (Column PGInt8) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGInt8) = Column (Nullable PGInt8)

data SqlFloat8 Source #

Instances

Instances details

SqlFractional SqlFloat8 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods pgFromRational :: Rational -> Column SqlFloat8 Source # sqlFromRational :: Rational -> Column SqlFloat8 Source #
SqlNum SqlFloat8 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods pgFromInteger :: Integer -> Column SqlFloat8 Source # sqlFromInteger :: Integer -> Column SqlFloat8 Source #
IsSqlType SqlFloat8 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlFloat8 -> String Source #
SqlOrd SqlFloat8 Source #
Instance details Defined in Opaleye.Order
DefaultFromField SqlFloat8 Double Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlFloat8 Double Source # defaultFromField :: FromField SqlFloat8 Double Source #
Default ToFields Double (Column SqlFloat8) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields Double (Column SqlFloat8) #
double ~ Double => Default (Inferrable FromField) SqlFloat8 double Source #
Instance details Defined in Opaleye.Internal.Inferrable Methods def :: Inferrable FromField SqlFloat8 double #
type Map Nulled (Column PGFloat8) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGFloat8) = Column (Nullable PGFloat8)

data SqlFloat4 Source #

Instances

Instances details

IsSqlType SqlFloat4 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlFloat4 -> String Source #
SqlOrd SqlFloat4 Source #
Instance details Defined in Opaleye.Order

data SqlDate Source #

Instances

Instances details

IsSqlType SqlDate Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlDate -> String Source #
IsRangeType SqlDate Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showRangeType :: proxy SqlDate -> String Source #
SqlOrd SqlDate Source #
Instance details Defined in Opaleye.Order
DefaultFromField SqlDate Day Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlDate Day Source # defaultFromField :: FromField SqlDate Day Source #
Default ToFields Day (Column SqlDate) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields Day (Column SqlDate) #
Default ToFields (PGRange Day) (Column (SqlRange SqlDate)) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields (PGRange Day) (Column (SqlRange SqlDate)) #
day ~ Day => Default (Inferrable FromField) SqlDate day Source #
Instance details Defined in Opaleye.Internal.Inferrable Methods def :: Inferrable FromField SqlDate day #
type Map Nulled (Column PGDate) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGDate) = Column (Nullable PGDate)

data SqlBool Source #

Instances

Instances details

IsSqlType SqlBool Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlBool -> String Source #
SqlOrd SqlBool Source #
Instance details Defined in Opaleye.Order
DefaultFromField SqlBool Bool Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField SqlBool Bool Source # defaultFromField :: FromField SqlBool Bool Source #
Default ToFields Bool (Column SqlBool) Source #
Instance details Defined in Opaleye.Internal.Constant Methods def :: ToFields Bool (Column SqlBool) #
bool ~ Bool => Default (Inferrable FromField) SqlBool bool Source #
Instance details Defined in Opaleye.Internal.Inferrable Methods def :: Inferrable FromField SqlBool bool #
type Map Nulled (Column PGBool) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGBool) = Column (Nullable PGBool)

class IsSqlType pgType => IsRangeType pgType where Source #

Methods

showRangeType :: proxy pgType -> String Source #

Instances

Instances details

IsRangeType SqlTimestamptz Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showRangeType :: proxy SqlTimestamptz -> String Source #
IsRangeType SqlTimestamp Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showRangeType :: proxy SqlTimestamp -> String Source #
IsRangeType SqlNumeric Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showRangeType :: proxy SqlNumeric -> String Source #
IsRangeType SqlInt4 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showRangeType :: proxy SqlInt4 -> String Source #
IsRangeType SqlInt8 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showRangeType :: proxy SqlInt8 -> String Source #
IsRangeType SqlDate Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showRangeType :: proxy SqlDate -> String Source #

pgString :: String -> Column PGText Source #

pgLazyByteString :: ByteString -> Column PGBytea Source #

pgStrictByteString :: ByteString -> Column PGBytea Source #

pgStrictText :: Text -> Column PGText Source #

pgLazyText :: Text -> Column PGText Source #

pgNumeric :: Scientific -> Column PGNumeric Source #

pgInt4 :: Int -> Column PGInt4 Source #

pgInt8 :: Int64 -> Column PGInt8 Source #

pgDouble :: Double -> Column PGFloat8 Source #

pgBool :: Bool -> Column PGBool Source #

pgUUID :: UUID -> Column PGUuid Source #

pgDay :: Day -> Column PGDate Source #

pgUTCTime :: UTCTime -> Column PGTimestamptz Source #

pgLocalTime :: LocalTime -> Column PGTimestamp Source #

pgZonedTime :: ZonedTime -> Column PGTimestamptz Source #

pgTimeOfDay :: TimeOfDay -> Column PGTime Source #

pgCiStrictText :: CI Text -> Column PGCitext Source #

pgCiLazyText :: CI Text -> Column PGCitext Source #

pgJSON :: String -> Column PGJson Source #

pgStrictJSON :: ByteString -> Column PGJson Source #

pgLazyJSON :: ByteString -> Column PGJson Source #

pgValueJSON :: ToJSON a => a -> Column PGJson Source #

pgJSONB :: String -> Column PGJsonb Source #

pgStrictJSONB :: ByteString -> Column PGJsonb Source #

pgLazyJSONB :: ByteString -> Column PGJsonb Source #

pgValueJSONB :: ToJSON a => a -> Column PGJsonb Source #

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

pgRange :: forall a b. IsRangeType b => (a -> Column b) -> RangeBound a -> RangeBound a -> Column (PGRange b) Source #

class IsSqlType sqlType where Source #

Methods

showSqlType :: proxy sqlType -> String Source #

Instances

Instances details

IsSqlType SqlJsonb Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlJsonb -> String Source #
IsSqlType SqlJson Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlJson -> String Source #
IsSqlType SqlBytea Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlBytea -> String Source #
IsSqlType SqlCitext Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlCitext -> String Source #
IsSqlType SqlUuid Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlUuid -> String Source #
IsSqlType SqlTimestamptz Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlTimestamptz -> String Source #
IsSqlType SqlTimestamp Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlTimestamp -> String Source #
IsSqlType SqlTime Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlTime -> String Source #
IsSqlType SqlText Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlText -> String Source #
IsSqlType SqlNumeric Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlNumeric -> String Source #
IsSqlType SqlInt2 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlInt2 -> String Source #
IsSqlType SqlInt4 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlInt4 -> String Source #
IsSqlType SqlInt8 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlInt8 -> String Source #
IsSqlType SqlFloat8 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlFloat8 -> String Source #
IsSqlType SqlFloat4 Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlFloat4 -> String Source #
IsSqlType SqlDate Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlDate -> String Source #
IsSqlType SqlBool Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy SqlBool -> String Source #
IsSqlType a => IsSqlType (Nullable a) Source #
Instance details Defined in Opaleye.Internal.PGTypes Methods showSqlType :: proxy (Nullable a) -> String Source #
IsRangeType a => IsSqlType (SqlRange a) Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy (SqlRange a) -> String Source #
IsSqlType a => IsSqlType (SqlArray a) Source #
Instance details Defined in Opaleye.Internal.PGTypesExternal Methods showSqlType :: proxy (SqlArray a) -> String Source #