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) (Field (SqlRange SqlInt4))

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Constant

Methods

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

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

Defined in Opaleye.Internal.Constant

Methods

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

IsRangeType a => IsSqlType (SqlRange a)

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlRange a) -> String

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

Defined in Opaleye.Internal.RunQuery

Methods

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

data SqlJsonb

Instances

IsSqlType SqlJsonb

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlJsonb -> String

SqlIsJson SqlJsonb

Defined in Opaleye.Operators

DefaultFromField SqlJsonb String

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlJsonb String

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 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 (Field SqlJsonb)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Field SqlJsonb)

Default ToFields ByteString (Field SqlJsonb)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Field SqlJsonb)

Default ToFields Value (Field SqlJsonb)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Value (Field SqlJsonb)

data SqlJson

Instances

IsSqlType SqlJson

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlJson -> String

SqlIsJson SqlJson

Defined in Opaleye.Operators

DefaultFromField SqlJson String

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField SqlJson String

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 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 (Field SqlJson)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Field SqlJson)

Default ToFields ByteString (Field SqlJson)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Field SqlJson)

Default ToFields Value (Field SqlJson)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Value (Field 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 (Field SqlBytea)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Field SqlBytea)

Default ToFields ByteString (Field SqlBytea)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Field SqlBytea)

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

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlBytea bytestring

type SqlArray = SqlArray_ NonNullable

data SqlArray_ (n :: Nullability) a

Instances

(Default ToFields a (Field_ n b), IsSqlType b) => Default ToFields [a] (Field (SqlArray_ n b))

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields [a] (Field (SqlArray_ n 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

(Typeable h, Default (Inferrable FromField) f h, hs ~ [Maybe h]) => Default (Inferrable FromField) (SqlArray_ 'Nullable f) hs

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField (SqlArray_ 'Nullable f) hs

IsSqlType a => IsSqlType (SqlArray_ n a)

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlArray_ n a) -> String

(Typeable b, DefaultFromField a b) => DefaultFromField (SqlArray_ 'NonNullable a) [b]

Defined in Opaleye.Internal.RunQuery

Methods

defaultFromField :: FromField (SqlArray_ 'NonNullable a) [b]

data SqlCitext

Instances

SqlString SqlCitext

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromString :: String -> Field SqlCitext

sqlFromString :: String -> Field 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) (Field SqlCitext)

Defined in Opaleye.Internal.Constant

Methods

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

Default ToFields (CI Text) (Field SqlCitext)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (CI Text) (Field 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 (Field SqlUuid)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields UUID (Field 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 (Field SqlTimestamptz)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields UTCTime (Field SqlTimestamptz)

Default ToFields ZonedTime (Field SqlTimestamptz)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ZonedTime (Field SqlTimestamptz)

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

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange UTCTime) (Field (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 (Field SqlTimestamp)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields LocalTime (Field SqlTimestamp)

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

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange LocalTime) (Field (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 (Field SqlTime)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields TimeOfDay (Field 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 -> Field SqlVarcharN

sqlFromString :: String -> Field 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 (Field SqlVarcharN)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields String (Field SqlVarcharN)

Default ToFields Text (Field SqlVarcharN)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Text (Field SqlVarcharN)

Default ToFields Text (Field SqlVarcharN)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Text (Field 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 -> Field SqlText

sqlFromString :: String -> Field 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 (Field SqlText)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields String (Field SqlText)

Default ToFields Text (Field SqlText)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Text (Field SqlText)

Default ToFields Text (Field SqlText)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Text (Field 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 -> Field SqlNumeric

sqlFromInteger :: Integer -> Field 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 (Field SqlNumeric)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Scientific (Field SqlNumeric)

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

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange Scientific) (Field (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 (Field SqlInterval)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields CalendarDiffTime (Field 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 -> Field SqlInt4

sqlFromInteger :: Integer -> Field 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 (Field SqlInt4)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Int (Field SqlInt4)

Default ToFields Int32 (Field SqlInt4)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Int32 (Field SqlInt4)

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

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange Int) (Field (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 -> Field SqlInt8

sqlFromInteger :: Integer -> Field 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 (Field SqlInt8)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Int64 (Field SqlInt8)

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

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange Int64) (Field (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 -> Field SqlFloat8

sqlFromRational :: Rational -> Field SqlFloat8

SqlNum SqlFloat8

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromInteger :: Integer -> Field SqlFloat8

sqlFromInteger :: Integer -> Field 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 (Field SqlFloat8)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Double (Field 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 (Field SqlDate)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Day (Field SqlDate)

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

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields (PGRange Day) (Field (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 (Field SqlBool)

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Bool (Field 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 -> Field PGText

pgLazyByteString :: ByteString -> Field PGBytea

pgStrictByteString :: ByteString -> Field PGBytea

pgStrictText :: Text -> Field PGText

pgLazyText :: Text -> Field PGText

sqlStringVarcharN :: String -> Field SqlVarcharN

sqlStrictTextVarcharN :: Text -> Field SqlVarcharN

sqlLazyTextVarcharN :: Text -> Field SqlVarcharN

pgNumeric :: Scientific -> Field PGNumeric

pgInt4 :: Int -> Field PGInt4

pgInt8 :: Int64 -> Field PGInt8

pgDouble :: Double -> Field PGFloat8

pgBool :: Bool -> Field PGBool

pgUUID :: UUID -> Field PGUuid

pgDay :: Day -> Field PGDate

pgUTCTime :: UTCTime -> Field PGTimestamptz

pgLocalTime :: LocalTime -> Field PGTimestamp

pgZonedTime :: ZonedTime -> Field PGTimestamptz

pgTimeOfDay :: TimeOfDay -> Field PGTime

sqlInterval :: CalendarDiffTime -> Field PGInterval

pgCiStrictText :: CI Text -> Field PGCitext

pgCiLazyText :: CI Text -> Field PGCitext

pgJSON :: String -> Field PGJson

pgStrictJSON :: ByteString -> Field PGJson

pgLazyJSON :: ByteString -> Field PGJson

pgValueJSON :: ToJSON a => a -> Field PGJson

pgJSONB :: String -> Field PGJsonb

pgStrictJSONB :: ByteString -> Field PGJsonb

pgLazyJSONB :: ByteString -> Field PGJsonb

pgValueJSONB :: ToJSON a => a -> Field PGJsonb

pgArray :: forall a b n. IsSqlType b => (a -> Field_ n b) -> [a] -> Field (SqlArray_ n b)

pgRange :: forall a b n n'. IsRangeType b => (a -> Field_ n b) -> RangeBound a -> RangeBound a -> Field_ n' (SqlRange 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

IsRangeType a => IsSqlType (SqlRange a)

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlRange a) -> String

IsSqlType a => IsSqlType (SqlArray_ n a)

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlArray_ n a) -> String