Opaleye.Internal.PGTypesExternal

Documentation

type PGRange = SqlRange

type PGJsonb = SqlJsonb

type PGJson = SqlJson

type PGBytea = SqlBytea

type PGArray = SqlArray

type PGCitext = SqlCitext

type PGUuid = SqlUuid

type PGTimestamptz = SqlTimestamptz

type PGTimestamp = SqlTimestamp

type PGTime = SqlTime

type PGText = SqlText

type PGNumeric = SqlNumeric

type PGInterval = SqlInterval

type PGInt2 = SqlInt2

type PGInt4 = SqlInt4

type PGInt8 = SqlInt8

type PGFloat8 = SqlFloat8

type PGFloat4 = SqlFloat4

type PGDate = SqlDate

type PGBool = SqlBool

data SqlRange a

Instances

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

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Constant

Methods

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

IsRangeType a => IsSqlType (SqlRange a)

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlRange a) -> String

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

Defined in Opaleye.Internal.RunQuery

Methods

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

data SqlJsonb

Instances

IsSqlType SqlJsonb

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlJsonb -> String

SqlIsJson SqlJsonb

Defined in Opaleye.Operators

DefaultFromField SqlJsonb ByteString

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlJsonb ByteString

DefaultFromField SqlJsonb ByteString

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlJsonb ByteString

DefaultFromField SqlJsonb String

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlJsonb String

DefaultFromField SqlJsonb Text

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlJsonb Text

DefaultFromField SqlJsonb Value

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlJsonb Value

DefaultFromField SqlJsonb Text

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlJsonb Text

Default ToFields ByteString (Column SqlJsonb)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlJsonb)

Default ToFields ByteString (Column SqlJsonb)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlJsonb)

Default ToFields Value (Column SqlJsonb)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Value (Column SqlJsonb)

data SqlJson

Instances

IsSqlType SqlJson

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlJson -> String

SqlIsJson SqlJson

Defined in Opaleye.Operators

DefaultFromField SqlJson ByteString

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlJson ByteString

DefaultFromField SqlJson ByteString

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlJson ByteString

DefaultFromField SqlJson String

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlJson String

DefaultFromField SqlJson Text

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlJson Text

DefaultFromField SqlJson Value

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlJson Value

DefaultFromField SqlJson Text

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlJson Text

Default ToFields ByteString (Column SqlJson)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlJson)

Default ToFields ByteString (Column SqlJson)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlJson)

Default ToFields Value (Column SqlJson)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Value (Column SqlJson)

data SqlBytea

Instances

IsSqlType SqlBytea

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlBytea -> String

DefaultFromField SqlBytea ByteString

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlBytea ByteString

DefaultFromField SqlBytea ByteString

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlBytea ByteString

Default ToFields ByteString (Column SqlBytea)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlBytea)

Default ToFields ByteString (Column SqlBytea)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlBytea)

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

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlBytea bytestring

data SqlArray a

Instances

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

Defined in Opaleye.Internal.Constant

Methods

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

IsSqlType a => IsSqlType (SqlArray a)

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlArray a) -> String

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

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField (SqlArray a) [b]

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

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField (SqlArray f) hs

data SqlCitext

Instances

SqlString SqlCitext

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromString :: String -> Column SqlCitext

sqlFromString :: String -> Column SqlCitext

IsSqlType SqlCitext

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlCitext -> String

SqlOrd SqlCitext

Defined in Opaleye.Order

DefaultFromField SqlCitext (CI Text)

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlCitext (CI Text)

DefaultFromField SqlCitext (CI Text)

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlCitext (CI Text)

Default ToFields (CI Text) (Column SqlCitext)

Defined in Opaleye.Internal.Constant

Methods

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

Default ToFields (CI Text) (Column SqlCitext)

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlCitext cttext

data SqlUuid

Instances

IsSqlType SqlUuid

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlUuid -> String

SqlOrd SqlUuid

Defined in Opaleye.Order

DefaultFromField SqlUuid UUID

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlUuid UUID

Default ToFields UUID (Column SqlUuid)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields UUID (Column SqlUuid)

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

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlUuid uuid

data SqlTimestamptz

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

IsSqlType SqlTimestamptz

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTimestamptz -> String

IsRangeType SqlTimestamptz

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlTimestamptz -> String

SqlOrd SqlTimestamptz

Defined in Opaleye.Order

DefaultFromField SqlTimestamptz UTCTime

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlTimestamptz UTCTime

DefaultFromField SqlTimestamptz ZonedTime

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlTimestamptz ZonedTime

IntervalNum SqlTimestamptz SqlTimestamptz

Defined in Opaleye.Operators

Default ToFields UTCTime (Column SqlTimestamptz)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields UTCTime (Column SqlTimestamptz)

Default ToFields ZonedTime (Column SqlTimestamptz)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ZonedTime (Column SqlTimestamptz)

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

Defined in Opaleye.Internal.Constant

Methods

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

data SqlTimestamp

Instances

IsSqlType SqlTimestamp

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTimestamp -> String

IsRangeType SqlTimestamp

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlTimestamp -> String

SqlOrd SqlTimestamp

Defined in Opaleye.Order

DefaultFromField SqlTimestamp LocalTime

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlTimestamp LocalTime

IntervalNum SqlTimestamp SqlTimestamp

Defined in Opaleye.Operators

IntervalNum SqlDate SqlTimestamp

Defined in Opaleye.Operators

Default ToFields LocalTime (Column SqlTimestamp)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields LocalTime (Column SqlTimestamp)

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

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlTimestamp localtime

data SqlTime

Instances

IsSqlType SqlTime

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTime -> String

SqlOrd SqlTime

Defined in Opaleye.Order

DefaultFromField SqlTime TimeOfDay

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlTime TimeOfDay

IntervalNum SqlTime SqlTime

Defined in Opaleye.Operators

Default ToFields TimeOfDay (Column SqlTime)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields TimeOfDay (Column SqlTime)

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

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlTime timeofday

data SqlVarcharN

VARCHAR(n) for any n. Opaleye does not do anything to check that the n you choose is correctly adhered to!

Instances

SqlString SqlVarcharN

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromString :: String -> Column SqlVarcharN

sqlFromString :: String -> Column SqlVarcharN

IsSqlType SqlVarcharN

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlVarcharN -> String

SqlOrd SqlVarcharN

Defined in Opaleye.Order

DefaultFromField SqlVarcharN String

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlVarcharN String

DefaultFromField SqlVarcharN Text

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlVarcharN Text

DefaultFromField SqlVarcharN Text

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlVarcharN Text

Default ToFields String (Column SqlVarcharN)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields String (Column SqlVarcharN)

Default ToFields Text (Column SqlVarcharN)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Text (Column SqlVarcharN)

Default ToFields Text (Column SqlVarcharN)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Text (Column SqlVarcharN)

varchar ~ Text => Default (Inferrable FromField) SqlVarcharN varchar

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlVarcharN varchar

data SqlText

Instances

SqlString SqlText

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromString :: String -> Column SqlText

sqlFromString :: String -> Column SqlText

IsSqlType SqlText

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlText -> String

SqlOrd SqlText

Defined in Opaleye.Order

SqlJsonIndex SqlText

Defined in Opaleye.Operators

DefaultFromField SqlText String

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlText String

DefaultFromField SqlText Text

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlText Text

DefaultFromField SqlText Text

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlText Text

Default ToFields String (Column SqlText)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields String (Column SqlText)

Default ToFields Text (Column SqlText)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Text (Column SqlText)

Default ToFields Text (Column SqlText)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Text (Column SqlText)

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

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlText text

data SqlNumeric

Instances

SqlIntegral SqlNumeric

Defined in Opaleye.Internal.PGTypesExternal

SqlNum SqlNumeric

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromInteger :: Integer -> Column SqlNumeric

sqlFromInteger :: Integer -> Column SqlNumeric

IsSqlType SqlNumeric

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlNumeric -> String

IsRangeType SqlNumeric

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlNumeric -> String

SqlOrd SqlNumeric

Defined in Opaleye.Order

DefaultFromField SqlNumeric Scientific

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlNumeric Scientific

Default ToFields Scientific (Column SqlNumeric)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Scientific (Column SqlNumeric)

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

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlNumeric scientific

data SqlInterval

Requires you to configure intervalstyle as iso_8601.

You can configure intervalstyle on every connection with a SET command, but for better performance you may want to configure it permanently in the file found with SHOW config_file;.

Instances

IsSqlType SqlInterval

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInterval -> String

DefaultFromField SqlInterval CalendarDiffTime

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlInterval CalendarDiffTime

IntervalNum SqlInterval SqlInterval

Defined in Opaleye.Operators

Default ToFields CalendarDiffTime (Column SqlInterval)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields CalendarDiffTime (Column SqlInterval)

calendardifftime ~ CalendarDiffTime => Default (Inferrable FromField) SqlInterval calendardifftime

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlInterval calendardifftime

data SqlInt2

Instances

SqlIntegral SqlInt2

Defined in Opaleye.Internal.PGTypesExternal

IsSqlType SqlInt2

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt2 -> String

SqlOrd SqlInt2

Defined in Opaleye.Order

data SqlInt4

Instances

SqlIntegral SqlInt4

Defined in Opaleye.Internal.PGTypesExternal

SqlNum SqlInt4

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromInteger :: Integer -> Column SqlInt4

sqlFromInteger :: Integer -> Column SqlInt4

IsSqlType SqlInt4

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt4 -> String

IsRangeType SqlInt4

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlInt4 -> String

SqlOrd SqlInt4

Defined in Opaleye.Order

SqlJsonIndex SqlInt4

Defined in Opaleye.Operators

DefaultFromField SqlInt4 Int

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlInt4 Int

DefaultFromField SqlInt4 Int32

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlInt4 Int32

Default ToFields Int (Column SqlInt4)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Int (Column SqlInt4)

Default ToFields Int32 (Column SqlInt4)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Int32 (Column SqlInt4)

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

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlInt4 int

data SqlInt8

Instances

SqlIntegral SqlInt8

Defined in Opaleye.Internal.PGTypesExternal

SqlNum SqlInt8

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromInteger :: Integer -> Column SqlInt8

sqlFromInteger :: Integer -> Column SqlInt8

IsSqlType SqlInt8

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt8 -> String

IsRangeType SqlInt8

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlInt8 -> String

SqlOrd SqlInt8

Defined in Opaleye.Order

SqlJsonIndex SqlInt8

Defined in Opaleye.Operators

DefaultFromField SqlInt8 Int64

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlInt8 Int64

Default ToFields Int64 (Column SqlInt8)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Int64 (Column SqlInt8)

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

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlInt8 int64

data SqlFloat8

Instances

SqlFractional SqlFloat8

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromRational :: Rational -> Column SqlFloat8

sqlFromRational :: Rational -> Column SqlFloat8

SqlNum SqlFloat8

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromInteger :: Integer -> Column SqlFloat8

sqlFromInteger :: Integer -> Column SqlFloat8

IsSqlType SqlFloat8

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlFloat8 -> String

SqlOrd SqlFloat8

Defined in Opaleye.Order

DefaultFromField SqlFloat8 Double

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlFloat8 Double

Default ToFields Double (Column SqlFloat8)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Double (Column SqlFloat8)

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

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlFloat8 double

data SqlFloat4

Instances

IsSqlType SqlFloat4

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlFloat4 -> String

SqlOrd SqlFloat4

Defined in Opaleye.Order

data SqlDate

Instances

IsSqlType SqlDate

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlDate -> String

IsRangeType SqlDate

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlDate -> String

SqlOrd SqlDate

Defined in Opaleye.Order

DefaultFromField SqlDate Day

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlDate Day

IntervalNum SqlDate SqlTimestamp

Defined in Opaleye.Operators

Default ToFields Day (Column SqlDate)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Day (Column SqlDate)

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

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlDate day

data SqlBool

Instances

IsSqlType SqlBool

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlBool -> String

SqlOrd SqlBool

Defined in Opaleye.Order

DefaultFromField SqlBool Bool

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlBool Bool

Default ToFields Bool (Column SqlBool)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Bool (Column SqlBool)

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

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlBool bool

class IsSqlType pgType => IsRangeType pgType where

Methods

showRangeType :: proxy pgType -> String

Instances

IsRangeType SqlTimestamptz

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlTimestamptz -> String

IsRangeType SqlTimestamp

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlTimestamp -> String

IsRangeType SqlNumeric

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlNumeric -> String

IsRangeType SqlInt4

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlInt4 -> String

IsRangeType SqlInt8

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlInt8 -> String

IsRangeType SqlDate

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlDate -> String

pgString :: String -> Column PGText

pgLazyByteString :: ByteString -> Column PGBytea

pgStrictByteString :: ByteString -> Column PGBytea

pgStrictText :: Text -> Column PGText

pgLazyText :: Text -> Column PGText

sqlStringVarcharN :: String -> Column SqlVarcharN

sqlStrictTextVarcharN :: Text -> Column SqlVarcharN

sqlLazyTextVarcharN :: Text -> Column SqlVarcharN

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

sqlInterval :: CalendarDiffTime -> Column PGInterval

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)

class IsSqlType sqlType where

Methods

showSqlType :: proxy sqlType -> String

Instances

IsSqlType SqlJsonb

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlJsonb -> String

IsSqlType SqlJson

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlJson -> String

IsSqlType SqlBytea

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlBytea -> String

IsSqlType SqlCitext

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlCitext -> String

IsSqlType SqlUuid

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlUuid -> String

IsSqlType SqlTimestamptz

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTimestamptz -> String

IsSqlType SqlTimestamp

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTimestamp -> String

IsSqlType SqlTime

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTime -> String

IsSqlType SqlVarcharN

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlVarcharN -> String

IsSqlType SqlText

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlText -> String

IsSqlType SqlNumeric

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlNumeric -> String

IsSqlType SqlInterval

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInterval -> String

IsSqlType SqlInt2

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt2 -> String

IsSqlType SqlInt4

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt4 -> String

IsSqlType SqlInt8

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt8 -> String

IsSqlType SqlFloat8

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlFloat8 -> String

IsSqlType SqlFloat4

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlFloat4 -> String

IsSqlType SqlDate

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlDate -> String

IsSqlType SqlBool

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlBool -> String

IsSqlType a => IsSqlType (Nullable a)

Defined in Opaleye.Internal.PGTypes

Methods

showSqlType :: proxy (Nullable a) -> String

IsRangeType a => IsSqlType (SqlRange a)

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlRange a) -> String

IsSqlType a => IsSqlType (SqlArray a)

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlArray a) -> String