Safe Haskell	None
Language	Haskell2010

Opaleye.PGTypes

Description

Postgres types and functions to create Columns of those types. You may find it more convenient to use Opaleye.Constant instead.

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
class IsSqlType sqlType where
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

Documentation

data PGRange a Source #

Instances

Default Constant (PGRange Int) (Column (SqlRange SqlInt4)) #
Instance details Defined in Opaleye.Constant Methods def :: Constant (PGRange Int) (Column (SqlRange SqlInt4)) #
Default Constant (PGRange Int64) (Column (SqlRange SqlInt8)) #
Instance details Defined in Opaleye.Constant Methods def :: Constant (PGRange Int64) (Column (SqlRange SqlInt8)) #
Default Constant (PGRange Scientific) (Column (SqlRange SqlNumeric)) #
Instance details Defined in Opaleye.Constant Methods def :: Constant (PGRange Scientific) (Column (SqlRange SqlNumeric)) #
Default Constant (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) #
Instance details Defined in Opaleye.Constant Methods def :: Constant (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) #
Default Constant (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) #
Instance details Defined in Opaleye.Constant Methods def :: Constant (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) #
Default Constant (PGRange Day) (Column (SqlRange SqlDate)) #
Instance details Defined in Opaleye.Constant Methods def :: Constant (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, QueryRunnerColumnDefault a b) => QueryRunnerColumnDefault (PGRange a) (PGRange b) Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: QueryRunnerColumn (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 String Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: QueryRunnerColumn PGJsonb String Source #
QueryRunnerColumnDefault PGJsonb Value Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: QueryRunnerColumn PGJsonb Value Source #
Default Constant ByteString (Column SqlJsonb) #
Instance details Defined in Opaleye.Constant Methods def :: Constant ByteString (Column SqlJsonb) #
Default Constant ByteString (Column SqlJsonb) #
Instance details Defined in Opaleye.Constant Methods def :: Constant ByteString (Column SqlJsonb) #
Default Constant Value (Column SqlJsonb) #
Instance details Defined in Opaleye.Constant Methods def :: Constant 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 String Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: QueryRunnerColumn PGJson String Source #
QueryRunnerColumnDefault PGJson Value Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: QueryRunnerColumn PGJson Value Source #
Default Constant ByteString (Column SqlJson) #
Instance details Defined in Opaleye.Constant Methods def :: Constant ByteString (Column SqlJson) #
Default Constant ByteString (Column SqlJson) #
Instance details Defined in Opaleye.Constant Methods def :: Constant ByteString (Column SqlJson) #
Default Constant Value (Column SqlJson) #
Instance details Defined in Opaleye.Constant Methods def :: Constant 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 :: QueryRunnerColumn PGBytea ByteString Source #
QueryRunnerColumnDefault PGBytea ByteString Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: QueryRunnerColumn PGBytea ByteString Source #
Default Constant ByteString (Column SqlBytea) #
Instance details Defined in Opaleye.Constant Methods def :: Constant ByteString (Column SqlBytea) #
Default Constant ByteString (Column SqlBytea) #
Instance details Defined in Opaleye.Constant Methods def :: Constant 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 Constant a (Column b), IsSqlType b) => Default Constant [a] (Column (SqlArray b)) #
Instance details Defined in Opaleye.Constant Methods def :: Constant [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, QueryRunnerColumnDefault a b) => QueryRunnerColumnDefault (PGArray a) [b] Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: QueryRunnerColumn (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 :: QueryRunnerColumn PGCitext (CI Text) Source #
QueryRunnerColumnDefault PGCitext (CI Text) Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: QueryRunnerColumn PGCitext (CI Text) Source #
Default Constant (CI Text) (Column SqlCitext) #
Instance details Defined in Opaleye.Constant Methods def :: Constant (CI Text) (Column SqlCitext) #
Default Constant (CI Text) (Column SqlCitext) #
Instance details Defined in Opaleye.Constant Methods def :: Constant (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 :: QueryRunnerColumn PGUuid UUID Source #
Default Constant UUID (Column SqlUuid) #
Instance details Defined in Opaleye.Constant Methods def :: Constant 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

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

IsRangeType PGTimestamp Source #
Instance details Defined in Opaleye.PGTypes Methods showRangeType :: proxy PGTimestamp -> String Source #
IsSqlType PGTimestamp Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGTimestamp -> String Source # showSqlType :: 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 :: QueryRunnerColumn PGTimestamp LocalTime Source #
Default Constant LocalTime (Column SqlTimestamp) #
Instance details Defined in Opaleye.Constant Methods def :: Constant LocalTime (Column SqlTimestamp) #
Default Constant (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) #
Instance details Defined in Opaleye.Constant Methods def :: Constant (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 :: QueryRunnerColumn PGTime TimeOfDay Source #
Default Constant TimeOfDay (Column SqlTime) #
Instance details Defined in Opaleye.Constant Methods def :: Constant 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 String Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: QueryRunnerColumn PGText String Source #
QueryRunnerColumnDefault PGText Text Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: QueryRunnerColumn PGText Text Source #
QueryRunnerColumnDefault PGText Text Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: QueryRunnerColumn PGText Text Source #
Default Constant String (Column SqlText) #
Instance details Defined in Opaleye.Constant Methods def :: Constant String (Column SqlText) #
Default Constant Text (Column SqlText) #
Instance details Defined in Opaleye.Constant Methods def :: Constant Text (Column SqlText) #
Default Constant Text (Column SqlText) #
Instance details Defined in Opaleye.Constant Methods def :: Constant Text (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
IsRangeType PGNumeric Source #
Instance details Defined in Opaleye.PGTypes Methods showRangeType :: proxy PGNumeric -> String Source #
IsSqlType PGNumeric Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGNumeric -> String Source # showSqlType :: 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 :: QueryRunnerColumn PGNumeric Scientific Source #
Default Constant Scientific (Column SqlNumeric) #
Instance details Defined in Opaleye.Constant Methods def :: Constant Scientific (Column SqlNumeric) #
Default Constant (PGRange Scientific) (Column (SqlRange SqlNumeric)) #
Instance details Defined in Opaleye.Constant Methods def :: Constant (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 #
IsRangeType PGInt4 Source #
Instance details Defined in Opaleye.PGTypes Methods showRangeType :: proxy PGInt4 -> String Source #
IsSqlType PGInt4 Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGInt4 -> String Source # showSqlType :: 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 :: QueryRunnerColumn PGInt4 Int Source #
QueryRunnerColumnDefault PGInt4 Int32 Source #
Instance details Defined in Opaleye.Internal.RunQuery Methods queryRunnerColumnDefault :: QueryRunnerColumn PGInt4 Int32 Source #
Default Constant Int (Column SqlInt4) #
Instance details Defined in Opaleye.Constant Methods def :: Constant Int (Column SqlInt4) #
Default Constant Int32 (Column SqlInt4) #
Instance details Defined in Opaleye.Constant Methods def :: Constant Int32 (Column SqlInt4) #
Default Constant (PGRange Int) (Column (SqlRange SqlInt4)) #
Instance details Defined in Opaleye.Constant Methods def :: Constant (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 #
IsRangeType PGInt8 Source #
Instance details Defined in Opaleye.PGTypes Methods showRangeType :: proxy PGInt8 -> String Source #
IsSqlType PGInt8 Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGInt8 -> String Source # showSqlType :: 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 :: QueryRunnerColumn PGInt8 Int64 Source #
Default Constant Int64 (Column SqlInt8) #
Instance details Defined in Opaleye.Constant Methods def :: Constant Int64 (Column SqlInt8) #
Default Constant (PGRange Int64) (Column (SqlRange SqlInt8)) #
Instance details Defined in Opaleye.Constant Methods def :: Constant (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 :: QueryRunnerColumn PGFloat8 Double Source #
Default Constant Double (Column SqlFloat8) #
Instance details Defined in Opaleye.Constant Methods def :: Constant 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

IsRangeType PGDate Source #
Instance details Defined in Opaleye.PGTypes Methods showRangeType :: proxy PGDate -> String Source #
IsSqlType PGDate Source #
Instance details Defined in Opaleye.PGTypes Methods showPGType :: proxy PGDate -> String Source # showSqlType :: 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 :: QueryRunnerColumn PGDate Day Source #
Default Constant Day (Column SqlDate) #
Instance details Defined in Opaleye.Constant Methods def :: Constant Day (Column SqlDate) #
Default Constant (PGRange Day) (Column (SqlRange SqlDate)) #
Instance details Defined in Opaleye.Constant Methods def :: Constant (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 :: QueryRunnerColumn PGBool Bool Source #
Default Constant Bool (Column SqlBool) #
Instance details Defined in Opaleye.Constant Methods def :: Constant 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 #

Minimal complete definition

showRangeType

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 #

class IsSqlType sqlType where Source #

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.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 #