IsSqlType PGJsonb #
Methods showPGType :: proxy PGJsonb -> String # showSqlType :: proxy PGJsonb -> String #
IsSqlType PGJson #
Methods showPGType :: proxy PGJson -> String # showSqlType :: proxy PGJson -> String #
IsSqlType PGBytea #
Methods showPGType :: proxy PGBytea -> String # showSqlType :: proxy PGBytea -> String #
IsSqlType PGCitext #
Methods showPGType :: proxy PGCitext -> String # showSqlType :: proxy PGCitext -> String #
IsSqlType PGUuid #
Methods showPGType :: proxy PGUuid -> String # showSqlType :: proxy PGUuid -> String #
IsSqlType PGTimestamptz #
Methods showPGType :: proxy PGTimestamptz -> String # showSqlType :: proxy PGTimestamptz -> String #
IsSqlType PGTimestamp #
Methods showPGType :: proxy PGTimestamp -> String # showSqlType :: proxy PGTimestamp -> String #
IsSqlType PGTime #
Methods showPGType :: proxy PGTime -> String # showSqlType :: proxy PGTime -> String #
IsSqlType PGText #
Methods showPGType :: proxy PGText -> String # showSqlType :: proxy PGText -> String #
IsSqlType PGNumeric #
Methods showPGType :: proxy PGNumeric -> String # showSqlType :: proxy PGNumeric -> String #
IsSqlType PGInt2 #
Methods showPGType :: proxy PGInt2 -> String # showSqlType :: proxy PGInt2 -> String #
IsSqlType PGInt4 #
Methods showPGType :: proxy PGInt4 -> String # showSqlType :: proxy PGInt4 -> String #
IsSqlType PGInt8 #
Methods showPGType :: proxy PGInt8 -> String # showSqlType :: proxy PGInt8 -> String #
IsSqlType PGFloat8 #
Methods showPGType :: proxy PGFloat8 -> String # showSqlType :: proxy PGFloat8 -> String #
IsSqlType PGFloat4 #
Methods showPGType :: proxy PGFloat4 -> String # showSqlType :: proxy PGFloat4 -> String #
IsSqlType PGDate #
Methods showPGType :: proxy PGDate -> String # showSqlType :: proxy PGDate -> String #
IsSqlType PGBool #
Methods showPGType :: proxy PGBool -> String # showSqlType :: proxy PGBool -> String #
IsSqlType a => IsSqlType (Nullable a) #
Methods showPGType :: proxy (Nullable a) -> String # showSqlType :: proxy (Nullable a) -> String #
IsRangeType a => IsSqlType (PGRange a) #
Methods showPGType :: proxy (PGRange a) -> String # showSqlType :: proxy (PGRange a) -> String #
IsSqlType a => IsSqlType (PGArray a) #
Methods showPGType :: proxy (PGArray a) -> String # showSqlType :: proxy (PGArray a) -> String #

class IsSqlType pgType => IsRangeType pgType where #

Minimal complete definition

showRangeType

Methods

showRangeType :: proxy pgType -> String #

Instances

IsRangeType PGTimestamptz #
Methods showRangeType :: proxy PGTimestamptz -> String #
IsRangeType PGTimestamp #
Methods showRangeType :: proxy PGTimestamp -> String #
IsRangeType PGNumeric #
Methods showRangeType :: proxy PGNumeric -> String #
IsRangeType PGInt4 #
Methods showRangeType :: proxy PGInt4 -> String #
IsRangeType PGInt8 #
Methods showRangeType :: proxy PGInt8 -> String #
IsRangeType PGDate #
Methods showRangeType :: proxy PGDate -> String #

SQL datatypes

data PGBool #

Instances

IsSqlType PGBool #
Methods showPGType :: proxy PGBool -> String # showSqlType :: proxy PGBool -> String #
PGOrd SqlBool #

QueryRunnerColumnDefault PGBool Bool #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGBool Bool #
Default Constant Bool (Column SqlBool) #
Methods def :: Constant Bool (Column SqlBool) #
type Map Nulled (Column PGBool) #
type Map Nulled (Column PGBool) = Column (Nullable PGBool)

data PGDate #

Instances

IsRangeType PGDate #
Methods showRangeType :: proxy PGDate -> String #
IsSqlType PGDate #
Methods showPGType :: proxy PGDate -> String # showSqlType :: proxy PGDate -> String #
PGOrd SqlDate #

QueryRunnerColumnDefault PGDate Day #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGDate Day #
Default Constant Day (Column SqlDate) #
Methods def :: Constant Day (Column SqlDate) #
Default Constant (PGRange Day) (Column (SqlRange SqlDate)) #
Methods def :: Constant (PGRange Day) (Column (SqlRange SqlDate)) #
type Map Nulled (Column PGDate) #
type Map Nulled (Column PGDate) = Column (Nullable PGDate)

data PGFloat4 #

Instances

IsSqlType PGFloat4 #
Methods showPGType :: proxy PGFloat4 -> String # showSqlType :: proxy PGFloat4 -> String #
PGOrd SqlFloat4 #

data PGFloat8 #

Instances

PGFractional PGFloat8 #
Methods pgFromRational :: Rational -> Column PGFloat8 # sqlFromRational :: Rational -> Column PGFloat8 #
PGNum PGFloat8 #
Methods pgFromInteger :: Integer -> Column PGFloat8 # sqlFromInteger :: Integer -> Column PGFloat8 #
IsSqlType PGFloat8 #
Methods showPGType :: proxy PGFloat8 -> String # showSqlType :: proxy PGFloat8 -> String #
PGOrd SqlFloat8 #

QueryRunnerColumnDefault PGFloat8 Double #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGFloat8 Double #
Default Constant Double (Column SqlFloat8) #
Methods def :: Constant Double (Column SqlFloat8) #
type Map Nulled (Column PGFloat8) #
type Map Nulled (Column PGFloat8) = Column (Nullable PGFloat8)

data PGInt8 #

Instances

PGIntegral PGInt8 #

PGNum PGInt8 #
Methods pgFromInteger :: Integer -> Column PGInt8 # sqlFromInteger :: Integer -> Column PGInt8 #
IsRangeType PGInt8 #
Methods showRangeType :: proxy PGInt8 -> String #
IsSqlType PGInt8 #
Methods showPGType :: proxy PGInt8 -> String # showSqlType :: proxy PGInt8 -> String #
PGOrd SqlInt8 #

PGJsonIndex SqlInt8 #

QueryRunnerColumnDefault PGInt8 Int64 #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGInt8 Int64 #
Default Constant Int64 (Column SqlInt8) #
Methods def :: Constant Int64 (Column SqlInt8) #
Default Constant (PGRange Int64) (Column (SqlRange SqlInt8)) #
Methods def :: Constant (PGRange Int64) (Column (SqlRange SqlInt8)) #
type Map Nulled (Column PGInt8) #
type Map Nulled (Column PGInt8) = Column (Nullable PGInt8)

data PGInt4 #

Instances

PGIntegral PGInt4 #

PGNum PGInt4 #
Methods pgFromInteger :: Integer -> Column PGInt4 # sqlFromInteger :: Integer -> Column PGInt4 #
IsRangeType PGInt4 #
Methods showRangeType :: proxy PGInt4 -> String #
IsSqlType PGInt4 #
Methods showPGType :: proxy PGInt4 -> String # showSqlType :: proxy PGInt4 -> String #
PGOrd SqlInt4 #

PGJsonIndex SqlInt4 #

QueryRunnerColumnDefault PGInt4 Int #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGInt4 Int #
QueryRunnerColumnDefault PGInt4 Int32 #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGInt4 Int32 #
Default Constant Int (Column SqlInt4) #
Methods def :: Constant Int (Column SqlInt4) #
Default Constant Int32 (Column SqlInt4) #
Methods def :: Constant Int32 (Column SqlInt4) #
Default Constant (PGRange Int) (Column (SqlRange SqlInt4)) #
Methods def :: Constant (PGRange Int) (Column (SqlRange SqlInt4)) #
type Map Nulled (Column PGInt4) #
type Map Nulled (Column PGInt4) = Column (Nullable PGInt4)

data PGInt2 #

Instances

PGIntegral PGInt2 #

IsSqlType PGInt2 #
Methods showPGType :: proxy PGInt2 -> String # showSqlType :: proxy PGInt2 -> String #
PGOrd SqlInt2 #

data PGNumeric #

Instances

PGIntegral PGNumeric #

IsRangeType PGNumeric #
Methods showRangeType :: proxy PGNumeric -> String #
IsSqlType PGNumeric #
Methods showPGType :: proxy PGNumeric -> String # showSqlType :: proxy PGNumeric -> String #
PGOrd SqlNumeric #

QueryRunnerColumnDefault PGNumeric Scientific #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGNumeric Scientific #
Default Constant Scientific (Column SqlNumeric) #
Methods def :: Constant Scientific (Column SqlNumeric) #
Default Constant (PGRange Scientific) (Column (SqlRange SqlNumeric)) #
Methods def :: Constant (PGRange Scientific) (Column (SqlRange SqlNumeric)) #

data PGText #

Instances

PGString PGText #
Methods pgFromString :: String -> Column PGText # sqlFromString :: String -> Column PGText #
IsSqlType PGText #
Methods showPGType :: proxy PGText -> String # showSqlType :: proxy PGText -> String #
PGOrd SqlText #

PGJsonIndex SqlText #

QueryRunnerColumnDefault PGText String #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGText String #
QueryRunnerColumnDefault PGText Text #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGText Text #
QueryRunnerColumnDefault PGText Text #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGText Text #
Default Constant String (Column SqlText) #
Methods def :: Constant String (Column SqlText) #
Default Constant Text (Column SqlText) #
Methods def :: Constant Text (Column SqlText) #
Default Constant Text (Column SqlText) #
Methods def :: Constant Text (Column SqlText) #
type Map Nulled (Column PGText) #
type Map Nulled (Column PGText) = Column (Nullable PGText)
type Map Nulled (Column PGText) #
type Map Nulled (Column PGText) = Column (Nullable PGText)

data PGTime #

Instances

IsSqlType PGTime #
Methods showPGType :: proxy PGTime -> String # showSqlType :: proxy PGTime -> String #
PGOrd SqlTime #

QueryRunnerColumnDefault PGTime TimeOfDay #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGTime TimeOfDay #
Default Constant TimeOfDay (Column SqlTime) #
Methods def :: Constant TimeOfDay (Column SqlTime) #
type Map Nulled (Column PGTime) #
type Map Nulled (Column PGTime) = Column (Nullable PGTime)

data PGTimestamp #

Instances

IsRangeType PGTimestamp #
Methods showRangeType :: proxy PGTimestamp -> String #
IsSqlType PGTimestamp #
Methods showPGType :: proxy PGTimestamp -> String # showSqlType :: proxy PGTimestamp -> String #
PGOrd SqlTimestamp #

QueryRunnerColumnDefault PGTimestamp LocalTime #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGTimestamp LocalTime #
Default Constant LocalTime (Column SqlTimestamp) #
Methods def :: Constant LocalTime (Column SqlTimestamp) #
Default Constant (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) #
Methods def :: Constant (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) #
type Map Nulled (Column PGTimestamp) #
type Map Nulled (Column PGTimestamp) = Column (Nullable PGTimestamp)

data PGTimestamptz #

Instances

IsRangeType PGTimestamptz #
Methods showRangeType :: proxy PGTimestamptz -> String #
IsSqlType PGTimestamptz #
Methods showPGType :: proxy PGTimestamptz -> String # showSqlType :: proxy PGTimestamptz -> String #
PGOrd SqlTimestamptz #

QueryRunnerColumnDefault PGTimestamptz UTCTime #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGTimestamptz UTCTime #
QueryRunnerColumnDefault PGTimestamptz ZonedTime #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGTimestamptz ZonedTime #
Default Constant UTCTime (Column SqlTimestamptz) #
Methods def :: Constant UTCTime (Column SqlTimestamptz) #
Default Constant ZonedTime (Column SqlTimestamptz) #
Methods def :: Constant ZonedTime (Column SqlTimestamptz) #
Default Constant (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) #
Methods def :: Constant (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) #
type Map Nulled (Column PGTimestamptz) #
type Map Nulled (Column PGTimestamptz) = Column (Nullable PGTimestamptz)

data PGUuid #

Instances

IsSqlType PGUuid #
Methods showPGType :: proxy PGUuid -> String # showSqlType :: proxy PGUuid -> String #
PGOrd SqlUuid #

QueryRunnerColumnDefault PGUuid UUID #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGUuid UUID #
Default Constant UUID (Column SqlUuid) #
Methods def :: Constant UUID (Column SqlUuid) #
type Map Nulled (Column PGUuid) #
type Map Nulled (Column PGUuid) = Column (Nullable PGUuid)

data PGCitext #

Instances

PGString PGCitext #
Methods pgFromString :: String -> Column PGCitext # sqlFromString :: String -> Column PGCitext #
IsSqlType PGCitext #
Methods showPGType :: proxy PGCitext -> String # showSqlType :: proxy PGCitext -> String #
PGOrd SqlCitext #

QueryRunnerColumnDefault PGCitext (CI Text) #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGCitext (CI Text) #
QueryRunnerColumnDefault PGCitext (CI Text) #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGCitext (CI Text) #
Default Constant (CI Text) (Column SqlCitext) #
Methods def :: Constant (CI Text) (Column SqlCitext) #
Default Constant (CI Text) (Column SqlCitext) #
Methods def :: Constant (CI Text) (Column SqlCitext) #
type Map Nulled (Column PGCitext) #
type Map Nulled (Column PGCitext) = Column (Nullable PGCitext)

data PGArray a #

Instances

(Default Constant a (Column b), IsSqlType b) => Default Constant [a] (Column (SqlArray b)) #
Methods def :: Constant [a] (Column (SqlArray b)) #
IsSqlType a => IsSqlType (PGArray a) #
Methods showPGType :: proxy (PGArray a) -> String # showSqlType :: proxy (PGArray a) -> String #
(Typeable * b, QueryRunnerColumnDefault a b) => QueryRunnerColumnDefault (PGArray a) [b] #
Methods queryRunnerColumnDefault :: QueryRunnerColumn (PGArray a) [b] #

data PGBytea #

Instances

IsSqlType PGBytea #
Methods showPGType :: proxy PGBytea -> String # showSqlType :: proxy PGBytea -> String #
QueryRunnerColumnDefault PGBytea ByteString #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGBytea ByteString #
QueryRunnerColumnDefault PGBytea ByteString #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGBytea ByteString #
Default Constant ByteString (Column SqlBytea) #
Methods def :: Constant ByteString (Column SqlBytea) #
Default Constant ByteString (Column SqlBytea) #
Methods def :: Constant ByteString (Column SqlBytea) #
type Map Nulled (Column PGBytea) #
type Map Nulled (Column PGBytea) = Column (Nullable PGBytea)

data PGJson #

Instances

IsSqlType PGJson #
Methods showPGType :: proxy PGJson -> String # showSqlType :: proxy PGJson -> String #
PGIsJson SqlJson #

QueryRunnerColumnDefault PGJson String #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGJson String #
QueryRunnerColumnDefault PGJson Value #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGJson Value #
Default Constant ByteString (Column SqlJson) #
Methods def :: Constant ByteString (Column SqlJson) #
Default Constant ByteString (Column SqlJson) #
Methods def :: Constant ByteString (Column SqlJson) #
Default Constant Value (Column SqlJson) #
Methods def :: Constant Value (Column SqlJson) #
type Map Nulled (Column PGJson) #
type Map Nulled (Column PGJson) = Column (Nullable PGJson)

data PGJsonb #

Instances

IsSqlType PGJsonb #
Methods showPGType :: proxy PGJsonb -> String # showSqlType :: proxy PGJsonb -> String #
PGIsJson SqlJsonb #

QueryRunnerColumnDefault PGJsonb String #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGJsonb String #
QueryRunnerColumnDefault PGJsonb Value #
Methods queryRunnerColumnDefault :: QueryRunnerColumn PGJsonb Value #
Default Constant ByteString (Column SqlJsonb) #
Methods def :: Constant ByteString (Column SqlJsonb) #
Default Constant ByteString (Column SqlJsonb) #
Methods def :: Constant ByteString (Column SqlJsonb) #
Default Constant Value (Column SqlJsonb) #
Methods def :: Constant Value (Column SqlJsonb) #
type Map Nulled (Column PGJsonb) #
type Map Nulled (Column PGJsonb) = Column (Nullable PGJsonb)

data PGRange a #

Instances

Default Constant (PGRange Int) (Column (SqlRange SqlInt4)) #
Methods def :: Constant (PGRange Int) (Column (SqlRange SqlInt4)) #
Default Constant (PGRange Int64) (Column (SqlRange SqlInt8)) #
Methods def :: Constant (PGRange Int64) (Column (SqlRange SqlInt8)) #
Default Constant (PGRange Scientific) (Column (SqlRange SqlNumeric)) #
Methods def :: Constant (PGRange Scientific) (Column (SqlRange SqlNumeric)) #
Default Constant (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) #
Methods def :: Constant (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) #
Default Constant (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) #
Methods def :: Constant (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) #
Default Constant (PGRange Day) (Column (SqlRange SqlDate)) #
Methods def :: Constant (PGRange Day) (Column (SqlRange SqlDate)) #
IsRangeType a => IsSqlType (PGRange a) #
Methods showPGType :: proxy (PGRange a) -> String # showSqlType :: proxy (PGRange a) -> String #
(Typeable * b, FromField b, QueryRunnerColumnDefault a b) => QueryRunnerColumnDefault (PGRange a) (PGRange b) #
Methods queryRunnerColumnDefault :: QueryRunnerColumn (PGRange a) (PGRange b) #

Deprecated functions

literalColumn :: Literal -> Column a #

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 #

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