Safe Haskell	None
Language	Haskell2010

Opaleye.PGTypes

Description

Use Opaleye.SqlTypes instead. Will be deprecated in version 0.7.

Synopsis

data PGRange a
data PGJsonb
data PGJson
data PGBytea
data PGArray a
data PGCitext
data PGUuid
data PGTimestamptz
data PGTimestamp
data PGTime
data PGText
data PGNumeric
data PGInt2
data PGInt4
data PGInt8
data PGFloat8
data PGFloat4
data PGDate
data PGBool
class IsSqlType pgType => IsRangeType pgType where
- showRangeType :: proxy pgType -> String
pgString :: String -> Column PGText
pgLazyByteString :: ByteString -> Column PGBytea
pgStrictByteString :: ByteString -> Column PGBytea
pgStrictText :: Text -> Column PGText
pgLazyText :: Text -> Column PGText
pgNumeric :: Scientific -> Column PGNumeric
pgInt4 :: Int -> Column PGInt4
pgInt8 :: Int64 -> Column PGInt8
pgDouble :: Double -> Column PGFloat8
pgBool :: Bool -> Column PGBool
pgUUID :: UUID -> Column PGUuid
pgDay :: Day -> Column PGDate
pgUTCTime :: UTCTime -> Column PGTimestamptz
pgLocalTime :: LocalTime -> Column PGTimestamp
pgZonedTime :: ZonedTime -> Column PGTimestamptz
pgTimeOfDay :: TimeOfDay -> Column PGTime
pgCiStrictText :: CI Text -> Column PGCitext
pgCiLazyText :: CI Text -> Column PGCitext
pgJSON :: String -> Column PGJson
pgStrictJSON :: ByteString -> Column PGJson
pgLazyJSON :: ByteString -> Column PGJson
pgValueJSON :: ToJSON a => a -> Column PGJson
pgJSONB :: String -> Column PGJsonb
pgStrictJSONB :: ByteString -> Column PGJsonb
pgLazyJSONB :: ByteString -> Column PGJsonb
pgValueJSONB :: ToJSON a => a -> Column PGJsonb
pgArray :: forall a b. IsSqlType b => (a -> Column b) -> [a] -> Column (PGArray b)
pgRange :: forall a b. IsRangeType b => (a -> Column b) -> RangeBound a -> RangeBound a -> Column (PGRange b)
literalColumn :: Literal -> Column a
unsafePgFormatTime :: FormatTime t => Name -> String -> t -> Column c
class IsSqlType sqlType where
- showPGType :: proxy sqlType -> String
- showSqlType :: proxy sqlType -> String

Documentation

data PGRange a Source #

Instances

Default ToFields (PGRange Int) (Column (SqlRange SqlInt4)) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields (PGRange Int) (Column (SqlRange SqlInt4)) #
Default ToFields (PGRange Int64) (Column (SqlRange SqlInt8)) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields (PGRange Int64) (Column (SqlRange SqlInt8)) #
Default ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric)) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric)) #
Default ToFields (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) #
Default ToFields (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) #
Default ToFields (PGRange Day) (Column (SqlRange SqlDate)) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields (PGRange Day) (Column (SqlRange SqlDate)) #
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 #
(Typeable b, FromField b, DefaultFromField a b) => QueryRunnerColumnDefault (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 PGJsonb Source #

Instances

IsSqlType PGJsonb Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGJsonb -> String Source # showSqlType :: proxy PGJsonb -> String Source #
PGIsJson SqlJsonb Source #
Instance details Defined in Opaleye.Operators
QueryRunnerColumnDefault PGJsonb Value Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGJsonb Value Source # defaultFromField :: FromField PGJsonb Value Source #
QueryRunnerColumnDefault PGJsonb String Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGJsonb String Source # defaultFromField :: FromField PGJsonb String Source #
Default ToFields ByteString (Column SqlJsonb) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields ByteString (Column SqlJsonb) #
Default ToFields ByteString (Column SqlJsonb) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields ByteString (Column SqlJsonb) #
Default ToFields Value (Column SqlJsonb) Source #
Instance details Defined in Opaleye.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 PGJson Source #

Instances

IsSqlType PGJson Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGJson -> String Source # showSqlType :: proxy PGJson -> String Source #
PGIsJson SqlJson Source #
Instance details Defined in Opaleye.Operators
QueryRunnerColumnDefault PGJson Value Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGJson Value Source # defaultFromField :: FromField PGJson Value Source #
QueryRunnerColumnDefault PGJson String Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGJson String Source # defaultFromField :: FromField PGJson String Source #
Default ToFields ByteString (Column SqlJson) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields ByteString (Column SqlJson) #
Default ToFields ByteString (Column SqlJson) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields ByteString (Column SqlJson) #
Default ToFields Value (Column SqlJson) Source #
Instance details Defined in Opaleye.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 PGBytea Source #

Instances

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

data PGArray a Source #

Instances

(Default ToFields a (Column b), IsSqlType b) => Default ToFields [a] (Column (SqlArray b)) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields [a] (Column (SqlArray b)) #
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 #
(Typeable b, DefaultFromField a b) => QueryRunnerColumnDefault (PGArray a) [b] Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField (PGArray a) [b] Source # defaultFromField :: FromField (PGArray a) [b] Source #

data PGCitext Source #

Instances

PGString PGCitext Source #
Instance details Defined in Opaleye.PGTypes Methods pgFromString :: String -> Column PGCitext Source # sqlFromString :: String -> Column PGCitext Source #
IsSqlType PGCitext Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGCitext -> String Source # showSqlType :: proxy PGCitext -> String Source #
PGOrd SqlCitext Source #
Instance details Defined in Opaleye.Order
QueryRunnerColumnDefault PGCitext (CI Text) Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGCitext (CI Text) Source # defaultFromField :: FromField PGCitext (CI Text) Source #
QueryRunnerColumnDefault PGCitext (CI Text) Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGCitext (CI Text) Source # defaultFromField :: FromField PGCitext (CI Text) Source #
Default ToFields (CI Text) (Column SqlCitext) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields (CI Text) (Column SqlCitext) #
Default ToFields (CI Text) (Column SqlCitext) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields (CI Text) (Column SqlCitext) #
type Map Nulled (Column PGCitext) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGCitext) = Column (Nullable PGCitext)

data PGUuid Source #

Instances

IsSqlType PGUuid Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGUuid -> String Source # showSqlType :: proxy PGUuid -> String Source #
PGOrd SqlUuid Source #
Instance details Defined in Opaleye.Order
QueryRunnerColumnDefault PGUuid UUID Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGUuid UUID Source # defaultFromField :: FromField PGUuid UUID Source #
Default ToFields UUID (Column SqlUuid) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields UUID (Column SqlUuid) #
type Map Nulled (Column PGUuid) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGUuid) = Column (Nullable PGUuid)

data PGTimestamptz Source #

Instances

IsSqlType PGTimestamptz Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGTimestamptz -> String Source # showSqlType :: proxy PGTimestamptz -> String Source #
IsRangeType PGTimestamptz Source #
Instance details Defined in Opaleye.PGTypes Methods showRangeType :: proxy PGTimestamptz -> String Source #
PGOrd SqlTimestamptz Source #
Instance details Defined in Opaleye.Order
QueryRunnerColumnDefault PGTimestamptz UTCTime Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGTimestamptz UTCTime Source # defaultFromField :: FromField PGTimestamptz UTCTime Source #
QueryRunnerColumnDefault PGTimestamptz ZonedTime Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGTimestamptz ZonedTime Source # defaultFromField :: FromField PGTimestamptz ZonedTime Source #
Default ToFields UTCTime (Column SqlTimestamptz) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields UTCTime (Column SqlTimestamptz) #
Default ToFields ZonedTime (Column SqlTimestamptz) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields ZonedTime (Column SqlTimestamptz) #
Default ToFields (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) Source #
Instance details Defined in Opaleye.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 PGTimestamp Source #

Instances

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

data PGTime Source #

Instances

IsSqlType PGTime Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGTime -> String Source # showSqlType :: proxy PGTime -> String Source #
PGOrd SqlTime Source #
Instance details Defined in Opaleye.Order
QueryRunnerColumnDefault PGTime TimeOfDay Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGTime TimeOfDay Source # defaultFromField :: FromField PGTime TimeOfDay Source #
Default ToFields TimeOfDay (Column SqlTime) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields TimeOfDay (Column SqlTime) #
type Map Nulled (Column PGTime) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGTime) = Column (Nullable PGTime)

data PGText Source #

Instances

PGString PGText Source #
Instance details Defined in Opaleye.PGTypes Methods pgFromString :: String -> Column PGText Source # sqlFromString :: String -> Column PGText Source #
IsSqlType PGText Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGText -> String Source # showSqlType :: proxy PGText -> String Source #
PGOrd SqlText Source #
Instance details Defined in Opaleye.Order
PGJsonIndex SqlText Source #
Instance details Defined in Opaleye.Operators
QueryRunnerColumnDefault PGText Text Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGText Text Source # defaultFromField :: FromField PGText Text Source #
QueryRunnerColumnDefault PGText Text Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGText Text Source # defaultFromField :: FromField PGText Text Source #
QueryRunnerColumnDefault PGText String Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGText String Source # defaultFromField :: FromField PGText String Source #
Default ToFields Text (Column SqlText) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields Text (Column SqlText) #
Default ToFields Text (Column SqlText) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields Text (Column SqlText) #
Default ToFields String (Column SqlText) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields String (Column SqlText) #
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 PGNumeric Source #

Instances

PGIntegral PGNumeric Source #
Instance details Defined in Opaleye.PGTypes
IsSqlType PGNumeric Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGNumeric -> String Source # showSqlType :: proxy PGNumeric -> String Source #
IsRangeType PGNumeric Source #
Instance details Defined in Opaleye.PGTypes Methods showRangeType :: proxy PGNumeric -> String Source #
PGOrd SqlNumeric Source #
Instance details Defined in Opaleye.Order
QueryRunnerColumnDefault PGNumeric Scientific Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGNumeric Scientific Source # defaultFromField :: FromField PGNumeric Scientific Source #
Default ToFields Scientific (Column SqlNumeric) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields Scientific (Column SqlNumeric) #
Default ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric)) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric)) #

data PGInt2 Source #

Instances

PGIntegral PGInt2 Source #
Instance details Defined in Opaleye.PGTypes
IsSqlType PGInt2 Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGInt2 -> String Source # showSqlType :: proxy PGInt2 -> String Source #
PGOrd SqlInt2 Source #
Instance details Defined in Opaleye.Order

data PGInt4 Source #

Instances

PGIntegral PGInt4 Source #
Instance details Defined in Opaleye.PGTypes
PGNum PGInt4 Source #
Instance details Defined in Opaleye.PGTypes Methods pgFromInteger :: Integer -> Column PGInt4 Source # sqlFromInteger :: Integer -> Column PGInt4 Source #
IsSqlType PGInt4 Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGInt4 -> String Source # showSqlType :: proxy PGInt4 -> String Source #
IsRangeType PGInt4 Source #
Instance details Defined in Opaleye.PGTypes Methods showRangeType :: proxy PGInt4 -> String Source #
PGOrd SqlInt4 Source #
Instance details Defined in Opaleye.Order
PGJsonIndex SqlInt4 Source #
Instance details Defined in Opaleye.Operators
QueryRunnerColumnDefault PGInt4 Int Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGInt4 Int Source # defaultFromField :: FromField PGInt4 Int Source #
QueryRunnerColumnDefault PGInt4 Int32 Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGInt4 Int32 Source # defaultFromField :: FromField PGInt4 Int32 Source #
Default ToFields Int (Column SqlInt4) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields Int (Column SqlInt4) #
Default ToFields Int32 (Column SqlInt4) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields Int32 (Column SqlInt4) #
Default ToFields (PGRange Int) (Column (SqlRange SqlInt4)) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields (PGRange Int) (Column (SqlRange SqlInt4)) #
type Map Nulled (Column PGInt4) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGInt4) = Column (Nullable PGInt4)

data PGInt8 Source #

Instances

PGIntegral PGInt8 Source #
Instance details Defined in Opaleye.PGTypes
PGNum PGInt8 Source #
Instance details Defined in Opaleye.PGTypes Methods pgFromInteger :: Integer -> Column PGInt8 Source # sqlFromInteger :: Integer -> Column PGInt8 Source #
IsSqlType PGInt8 Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGInt8 -> String Source # showSqlType :: proxy PGInt8 -> String Source #
IsRangeType PGInt8 Source #
Instance details Defined in Opaleye.PGTypes Methods showRangeType :: proxy PGInt8 -> String Source #
PGOrd SqlInt8 Source #
Instance details Defined in Opaleye.Order
PGJsonIndex SqlInt8 Source #
Instance details Defined in Opaleye.Operators
QueryRunnerColumnDefault PGInt8 Int64 Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGInt8 Int64 Source # defaultFromField :: FromField PGInt8 Int64 Source #
Default ToFields Int64 (Column SqlInt8) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields Int64 (Column SqlInt8) #
Default ToFields (PGRange Int64) (Column (SqlRange SqlInt8)) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields (PGRange Int64) (Column (SqlRange SqlInt8)) #
type Map Nulled (Column PGInt8) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGInt8) = Column (Nullable PGInt8)

data PGFloat8 Source #

Instances

PGFractional PGFloat8 Source #
Instance details Defined in Opaleye.PGTypes Methods pgFromRational :: Rational -> Column PGFloat8 Source # sqlFromRational :: Rational -> Column PGFloat8 Source #
PGNum PGFloat8 Source #
Instance details Defined in Opaleye.PGTypes Methods pgFromInteger :: Integer -> Column PGFloat8 Source # sqlFromInteger :: Integer -> Column PGFloat8 Source #
IsSqlType PGFloat8 Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGFloat8 -> String Source # showSqlType :: proxy PGFloat8 -> String Source #
PGOrd SqlFloat8 Source #
Instance details Defined in Opaleye.Order
QueryRunnerColumnDefault PGFloat8 Double Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGFloat8 Double Source # defaultFromField :: FromField PGFloat8 Double Source #
Default ToFields Double (Column SqlFloat8) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields Double (Column SqlFloat8) #
type Map Nulled (Column PGFloat8) Source #
Instance details Defined in Opaleye.Internal.Join type Map Nulled (Column PGFloat8) = Column (Nullable PGFloat8)

data PGFloat4 Source #

Instances

IsSqlType PGFloat4 Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGFloat4 -> String Source # showSqlType :: proxy PGFloat4 -> String Source #
PGOrd SqlFloat4 Source #
Instance details Defined in Opaleye.Order

data PGDate Source #

Instances

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

data PGBool Source #

Instances

IsSqlType PGBool Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGBool -> String Source # showSqlType :: proxy PGBool -> String Source #
PGOrd SqlBool Source #
Instance details Defined in Opaleye.Order
QueryRunnerColumnDefault PGBool Bool Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: FromField PGBool Bool Source # defaultFromField :: FromField PGBool Bool Source #
Default ToFields Bool (Column SqlBool) Source #
Instance details Defined in Opaleye.Constant Methods def :: ToFields Bool (Column SqlBool) #
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

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 #

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 #

literalColumn :: Literal -> Column a Source #

Deprecated: literalColumn has been moved to Opaleye.Internal.PGTypes and will be removed in version 0.7.

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

Deprecated: unsafePgFormatTime has been moved to Opaleye.Internal.PGTypes and will be removed in version 0.7.

class IsSqlType sqlType where Source #

Minimal complete definition

showPGType | showSqlType

Methods

showPGType :: proxy sqlType -> String Source #

Deprecated: Use showSqlType instead. showPGType will be removed in version 0.7.

showSqlType :: proxy sqlType -> String Source #

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 #