opaleye-0.7.3.0: An SQL-generating DSL targeting PostgreSQL
Safe HaskellNone
LanguageHaskell2010

Opaleye.SqlTypes

Description

SQL types and functions to create Field_s of those types. To create fields you may find it more convenient to use Opaleye.ToFields instead.

Synopsis

Numeric

Creating values

sqlInt4 :: Int -> Field SqlInt4 Source #

sqlDouble :: Double -> Field SqlFloat8 Source #

sqlInt8 :: Int64 -> Field SqlInt8 Source #

sqlNumeric :: Scientific -> Field SqlNumeric Source #

Types

data SqlInt4 Source #

Instances

Instances details
SqlIntegral SqlInt4 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

SqlNum SqlInt4 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromInteger :: Integer -> Column SqlInt4 Source #

sqlFromInteger :: Integer -> Column SqlInt4 Source #

IsSqlType SqlInt4 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt4 -> String Source #

IsRangeType SqlInt4 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlInt4 -> String Source #

SqlOrd SqlInt4 Source # 
Instance details

Defined in Opaleye.Order

SqlJsonIndex SqlInt4 Source # 
Instance details

Defined in Opaleye.Operators

DefaultFromField SqlInt4 Int Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlInt4 Int Source #

defaultFromField :: FromField SqlInt4 Int Source #

DefaultFromField SqlInt4 Int32 Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlInt4 Int32 Source #

defaultFromField :: FromField SqlInt4 Int32 Source #

Default ToFields Int (Column SqlInt4) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Int (Column SqlInt4) #

Default ToFields Int32 (Column SqlInt4) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Int32 (Column SqlInt4) #

Default ToFields (PGRange Int) (Column (SqlRange SqlInt4)) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

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

int ~ Int => Default (Inferrable FromField) SqlInt4 int Source # 
Instance details

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlInt4 int #

type Map Nulled (Column PGInt4) Source # 
Instance details

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGInt4) = Column (Nullable PGInt4)

data SqlFloat8 Source #

Instances

Instances details
SqlFractional SqlFloat8 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromRational :: Rational -> Column SqlFloat8 Source #

sqlFromRational :: Rational -> Column SqlFloat8 Source #

SqlNum SqlFloat8 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromInteger :: Integer -> Column SqlFloat8 Source #

sqlFromInteger :: Integer -> Column SqlFloat8 Source #

IsSqlType SqlFloat8 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlFloat8 -> String Source #

SqlOrd SqlFloat8 Source # 
Instance details

Defined in Opaleye.Order

DefaultFromField SqlFloat8 Double Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlFloat8 Double Source #

defaultFromField :: FromField SqlFloat8 Double Source #

Default ToFields Double (Column SqlFloat8) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Double (Column SqlFloat8) #

double ~ Double => Default (Inferrable FromField) SqlFloat8 double Source # 
Instance details

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlFloat8 double #

type Map Nulled (Column PGFloat8) Source # 
Instance details

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGFloat8) = Column (Nullable PGFloat8)

data SqlNumeric Source #

Instances

Instances details
SqlIntegral SqlNumeric Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

SqlNum SqlNumeric Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromInteger :: Integer -> Column SqlNumeric Source #

sqlFromInteger :: Integer -> Column SqlNumeric Source #

IsSqlType SqlNumeric Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlNumeric -> String Source #

IsRangeType SqlNumeric Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlNumeric -> String Source #

SqlOrd SqlNumeric Source # 
Instance details

Defined in Opaleye.Order

DefaultFromField SqlNumeric Scientific Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlNumeric Scientific Source #

defaultFromField :: FromField SqlNumeric Scientific Source #

Default ToFields Scientific (Column SqlNumeric) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Scientific (Column SqlNumeric) #

Default ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric)) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

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

scientific ~ Scientific => Default (Inferrable FromField) SqlNumeric scientific Source # 
Instance details

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlNumeric scientific #

data SqlInt8 Source #

Instances

Instances details
SqlIntegral SqlInt8 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

SqlNum SqlInt8 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromInteger :: Integer -> Column SqlInt8 Source #

sqlFromInteger :: Integer -> Column SqlInt8 Source #

IsSqlType SqlInt8 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt8 -> String Source #

IsRangeType SqlInt8 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlInt8 -> String Source #

SqlOrd SqlInt8 Source # 
Instance details

Defined in Opaleye.Order

SqlJsonIndex SqlInt8 Source # 
Instance details

Defined in Opaleye.Operators

DefaultFromField SqlInt8 Int64 Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlInt8 Int64 Source #

defaultFromField :: FromField SqlInt8 Int64 Source #

Default ToFields Int64 (Column SqlInt8) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Int64 (Column SqlInt8) #

Default ToFields (PGRange Int64) (Column (SqlRange SqlInt8)) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

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

int64 ~ Int64 => Default (Inferrable FromField) SqlInt8 int64 Source # 
Instance details

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlInt8 int64 #

type Map Nulled (Column PGInt8) Source # 
Instance details

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGInt8) = Column (Nullable PGInt8)

data SqlInt2 Source #

Instances

Instances details
SqlIntegral SqlInt2 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

IsSqlType SqlInt2 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt2 -> String Source #

SqlOrd SqlInt2 Source # 
Instance details

Defined in Opaleye.Order

data SqlFloat4 Source #

Instances

Instances details
IsSqlType SqlFloat4 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlFloat4 -> String Source #

SqlOrd SqlFloat4 Source # 
Instance details

Defined in Opaleye.Order

Date and time

Creating values

sqlDay :: Day -> Field SqlDate Source #

sqlUTCTime :: UTCTime -> Field SqlTimestamptz Source #

sqlLocalTime :: LocalTime -> Field SqlTimestamp Source #

sqlZonedTime :: ZonedTime -> Field SqlTimestamptz Source #

sqlTimeOfDay :: TimeOfDay -> Field SqlTime Source #

Types

data SqlDate Source #

Instances

Instances details
IsSqlType SqlDate Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlDate -> String Source #

IsRangeType SqlDate Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlDate -> String Source #

SqlOrd SqlDate Source # 
Instance details

Defined in Opaleye.Order

DefaultFromField SqlDate Day Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlDate Day Source #

defaultFromField :: FromField SqlDate Day Source #

Default ToFields Day (Column SqlDate) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Day (Column SqlDate) #

Default ToFields (PGRange Day) (Column (SqlRange SqlDate)) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

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

day ~ Day => Default (Inferrable FromField) SqlDate day Source # 
Instance details

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlDate day #

type Map Nulled (Column PGDate) Source # 
Instance details

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGDate) = Column (Nullable PGDate)

data SqlTime Source #

Instances

Instances details
IsSqlType SqlTime Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTime -> String Source #

SqlOrd SqlTime Source # 
Instance details

Defined in Opaleye.Order

DefaultFromField SqlTime TimeOfDay Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlTime TimeOfDay Source #

defaultFromField :: FromField SqlTime TimeOfDay Source #

Default ToFields TimeOfDay (Column SqlTime) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields TimeOfDay (Column SqlTime) #

timeofday ~ TimeOfDay => Default (Inferrable FromField) SqlTime timeofday Source # 
Instance details

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlTime timeofday #

type Map Nulled (Column PGTime) Source # 
Instance details

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGTime) = Column (Nullable PGTime)

data SqlTimestamp Source #

Instances

Instances details
IsSqlType SqlTimestamp Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTimestamp -> String Source #

IsRangeType SqlTimestamp Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlTimestamp -> String Source #

SqlOrd SqlTimestamp Source # 
Instance details

Defined in Opaleye.Order

DefaultFromField SqlTimestamp LocalTime Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlTimestamp LocalTime Source #

defaultFromField :: FromField SqlTimestamp LocalTime Source #

Default ToFields LocalTime (Column SqlTimestamp) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields LocalTime (Column SqlTimestamp) #

Default ToFields (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

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

localtime ~ LocalTime => Default (Inferrable FromField) SqlTimestamp localtime Source # 
Instance details

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlTimestamp localtime #

type Map Nulled (Column PGTimestamp) Source # 
Instance details

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGTimestamp) = Column (Nullable PGTimestamp)

data SqlTimestamptz Source #

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

Instances details
IsSqlType SqlTimestamptz Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTimestamptz -> String Source #

IsRangeType SqlTimestamptz Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlTimestamptz -> String Source #

SqlOrd SqlTimestamptz Source # 
Instance details

Defined in Opaleye.Order

DefaultFromField SqlTimestamptz UTCTime Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlTimestamptz UTCTime Source #

defaultFromField :: FromField SqlTimestamptz UTCTime Source #

DefaultFromField SqlTimestamptz ZonedTime Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlTimestamptz ZonedTime Source #

defaultFromField :: FromField SqlTimestamptz ZonedTime Source #

Default ToFields UTCTime (Column SqlTimestamptz) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields UTCTime (Column SqlTimestamptz) #

Default ToFields ZonedTime (Column SqlTimestamptz) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ZonedTime (Column SqlTimestamptz) #

Default ToFields (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

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

type Map Nulled (Column PGTimestamptz) Source # 
Instance details

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGTimestamptz) = Column (Nullable PGTimestamptz)

JSON

Creating values

sqlJSON :: String -> Field SqlJson Source #

sqlStrictJSON :: ByteString -> Field SqlJson Source #

sqlLazyJSON :: ByteString -> Field SqlJson Source #

sqlValueJSON :: ToJSON a => a -> Field SqlJson Source #

Types

data SqlJson Source #

Instances

Instances details
IsSqlType SqlJson Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlJson -> String Source #

SqlIsJson SqlJson Source # 
Instance details

Defined in Opaleye.Operators

DefaultFromField SqlJson ByteString Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJson ByteString Source #

defaultFromField :: FromField SqlJson ByteString Source #

DefaultFromField SqlJson ByteString Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJson ByteString Source #

defaultFromField :: FromField SqlJson ByteString Source #

DefaultFromField SqlJson String Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJson String Source #

defaultFromField :: FromField SqlJson String Source #

DefaultFromField SqlJson Text Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJson Text Source #

defaultFromField :: FromField SqlJson Text Source #

DefaultFromField SqlJson Value Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJson Value Source #

defaultFromField :: FromField SqlJson Value Source #

DefaultFromField SqlJson Text Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJson Text Source #

defaultFromField :: FromField SqlJson Text Source #

Default ToFields ByteString (Column SqlJson) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlJson) #

Default ToFields ByteString (Column SqlJson) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlJson) #

Default ToFields Value (Column SqlJson) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Value (Column SqlJson) #

type Map Nulled (Column PGJson) Source # 
Instance details

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGJson) = Column (Nullable PGJson)

JSONB

Creating values

sqlJSONB :: String -> Field SqlJsonb Source #

sqlStrictJSONB :: ByteString -> Field SqlJsonb Source #

sqlLazyJSONB :: ByteString -> Field SqlJsonb Source #

sqlValueJSONB :: ToJSON a => a -> Field SqlJsonb Source #

Types

data SqlJsonb Source #

Instances

Instances details
IsSqlType SqlJsonb Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlJsonb -> String Source #

SqlIsJson SqlJsonb Source # 
Instance details

Defined in Opaleye.Operators

DefaultFromField SqlJsonb ByteString Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJsonb ByteString Source #

defaultFromField :: FromField SqlJsonb ByteString Source #

DefaultFromField SqlJsonb ByteString Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJsonb ByteString Source #

defaultFromField :: FromField SqlJsonb ByteString Source #

DefaultFromField SqlJsonb String Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJsonb String Source #

defaultFromField :: FromField SqlJsonb String Source #

DefaultFromField SqlJsonb Text Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJsonb Text Source #

defaultFromField :: FromField SqlJsonb Text Source #

DefaultFromField SqlJsonb Value Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJsonb Value Source #

defaultFromField :: FromField SqlJsonb Value Source #

DefaultFromField SqlJsonb Text Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlJsonb Text Source #

defaultFromField :: FromField SqlJsonb Text Source #

Default ToFields ByteString (Column SqlJsonb) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlJsonb) #

Default ToFields ByteString (Column SqlJsonb) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlJsonb) #

Default ToFields Value (Column SqlJsonb) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Value (Column SqlJsonb) #

type Map Nulled (Column PGJsonb) Source # 
Instance details

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGJsonb) = Column (Nullable PGJsonb)

Text

Creating values

sqlString :: String -> Field SqlText Source #

sqlStrictText :: Text -> Field SqlText Source #

sqlLazyText :: Text -> Field SqlText Source #

sqlCiStrictText :: CI Text -> Field SqlCitext Source #

sqlCiLazyText :: CI Text -> Field SqlCitext Source #

Types

data SqlText Source #

Instances

Instances details
SqlString SqlText Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromString :: String -> Column SqlText Source #

sqlFromString :: String -> Column SqlText Source #

IsSqlType SqlText Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlText -> String Source #

SqlOrd SqlText Source # 
Instance details

Defined in Opaleye.Order

SqlJsonIndex SqlText Source # 
Instance details

Defined in Opaleye.Operators

DefaultFromField SqlText String Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlText String Source #

defaultFromField :: FromField SqlText String Source #

DefaultFromField SqlText Text Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlText Text Source #

defaultFromField :: FromField SqlText Text Source #

DefaultFromField SqlText Text Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlText Text Source #

defaultFromField :: FromField SqlText Text Source #

Default ToFields String (Column SqlText) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields String (Column SqlText) #

Default ToFields Text (Column SqlText) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Text (Column SqlText) #

Default ToFields Text (Column SqlText) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Text (Column SqlText) #

text ~ Text => Default (Inferrable FromField) SqlText text Source # 
Instance details

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlText text #

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 SqlCitext Source #

Instances

Instances details
SqlString SqlCitext Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

pgFromString :: String -> Column SqlCitext Source #

sqlFromString :: String -> Column SqlCitext Source #

IsSqlType SqlCitext Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlCitext -> String Source #

SqlOrd SqlCitext Source # 
Instance details

Defined in Opaleye.Order

DefaultFromField SqlCitext (CI Text) Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlCitext (CI Text) Source #

defaultFromField :: FromField SqlCitext (CI Text) Source #

DefaultFromField SqlCitext (CI Text) Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlCitext (CI Text) Source #

defaultFromField :: FromField SqlCitext (CI Text) Source #

Default ToFields (CI Text) (Column SqlCitext) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

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

Default ToFields (CI Text) (Column SqlCitext) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

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

cttext ~ CI Text => Default (Inferrable FromField) SqlCitext cttext Source # 
Instance details

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlCitext cttext #

type Map Nulled (Column PGCitext) Source # 
Instance details

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGCitext) = Column (Nullable PGCitext)

Array

Creating values

sqlArray :: IsSqlType b => (a -> Field b) -> [a] -> Field (SqlArray b) Source #

Types

data SqlArray a Source #

Instances

Instances details
(Default ToFields a (Column b), IsSqlType b) => Default ToFields [a] (Column (SqlArray b)) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

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

IsSqlType a => IsSqlType (SqlArray a) Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlArray a) -> String Source #

(Typeable b, DefaultFromField a b) => DefaultFromField (SqlArray a) [b] Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField (SqlArray a) [b] Source #

defaultFromField :: FromField (SqlArray a) [b] Source #

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

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField (SqlArray f) hs #

Range

Creating values

sqlRange :: IsRangeType b => (a -> Field b) -> RangeBound a -> RangeBound a -> Field (SqlRange b) Source #

Types

data SqlRange a Source #

Instances

Instances details
Default ToFields (PGRange Int) (Column (SqlRange SqlInt4)) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

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

Default ToFields (PGRange Int64) (Column (SqlRange SqlInt8)) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

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

Default ToFields (PGRange Scientific) (Column (SqlRange SqlNumeric)) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

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

Default ToFields (PGRange UTCTime) (Column (SqlRange SqlTimestamptz)) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

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

Default ToFields (PGRange LocalTime) (Column (SqlRange SqlTimestamp)) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

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

Default ToFields (PGRange Day) (Column (SqlRange SqlDate)) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

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

IsRangeType a => IsSqlType (SqlRange a) Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlRange a) -> String Source #

(Typeable b, DefaultFromField a b) => DefaultFromField (PGRange a) (PGRange b) Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField (PGRange a) (PGRange0 b) Source #

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

class IsSqlType pgType => IsRangeType pgType Source #

Minimal complete definition

showRangeType

Instances

Instances details
IsRangeType SqlTimestamptz Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlTimestamptz -> String Source #

IsRangeType SqlTimestamp Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlTimestamp -> String Source #

IsRangeType SqlNumeric Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlNumeric -> String Source #

IsRangeType SqlInt4 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlInt4 -> String Source #

IsRangeType SqlInt8 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlInt8 -> String Source #

IsRangeType SqlDate Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showRangeType :: proxy SqlDate -> String Source #

Other

Creating values

sqlBool :: Bool -> Field SqlBool Source #

sqlUUID :: UUID -> Field SqlUuid Source #

sqlLazyByteString :: ByteString -> Field SqlBytea Source #

sqlStrictByteString :: ByteString -> Field SqlBytea Source #

Types

data SqlBool Source #

Instances

Instances details
IsSqlType SqlBool Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlBool -> String Source #

SqlOrd SqlBool Source # 
Instance details

Defined in Opaleye.Order

DefaultFromField SqlBool Bool Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlBool Bool Source #

defaultFromField :: FromField SqlBool Bool Source #

Default ToFields Bool (Column SqlBool) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields Bool (Column SqlBool) #

bool ~ Bool => Default (Inferrable FromField) SqlBool bool Source # 
Instance details

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlBool bool #

type Map Nulled (Column PGBool) Source # 
Instance details

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGBool) = Column (Nullable PGBool)

data SqlUuid Source #

Instances

Instances details
IsSqlType SqlUuid Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlUuid -> String Source #

SqlOrd SqlUuid Source # 
Instance details

Defined in Opaleye.Order

DefaultFromField SqlUuid UUID Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlUuid UUID Source #

defaultFromField :: FromField SqlUuid UUID Source #

Default ToFields UUID (Column SqlUuid) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields UUID (Column SqlUuid) #

uuid ~ UUID => Default (Inferrable FromField) SqlUuid uuid Source # 
Instance details

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlUuid uuid #

type Map Nulled (Column PGUuid) Source # 
Instance details

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGUuid) = Column (Nullable PGUuid)

data SqlBytea Source #

Instances

Instances details
IsSqlType SqlBytea Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlBytea -> String Source #

DefaultFromField SqlBytea ByteString Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlBytea ByteString Source #

defaultFromField :: FromField SqlBytea ByteString Source #

DefaultFromField SqlBytea ByteString Source # 
Instance details

Defined in Opaleye.Internal.RunQuery

Methods

queryRunnerColumnDefault :: FromField SqlBytea ByteString Source #

defaultFromField :: FromField SqlBytea ByteString Source #

Default ToFields ByteString (Column SqlBytea) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlBytea) #

Default ToFields ByteString (Column SqlBytea) Source # 
Instance details

Defined in Opaleye.Internal.Constant

Methods

def :: ToFields ByteString (Column SqlBytea) #

bytestring ~ ByteString => Default (Inferrable FromField) SqlBytea bytestring Source # 
Instance details

Defined in Opaleye.Internal.Inferrable

Methods

def :: Inferrable FromField SqlBytea bytestring #

type Map Nulled (Column PGBytea) Source # 
Instance details

Defined in Opaleye.Internal.Join

type Map Nulled (Column PGBytea) = Column (Nullable PGBytea)

IsSqlType

class IsSqlType sqlType Source #

Minimal complete definition

showSqlType

Instances

Instances details
IsSqlType SqlJsonb Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlJsonb -> String Source #

IsSqlType SqlJson Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlJson -> String Source #

IsSqlType SqlBytea Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlBytea -> String Source #

IsSqlType SqlCitext Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlCitext -> String Source #

IsSqlType SqlUuid Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlUuid -> String Source #

IsSqlType SqlTimestamptz Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTimestamptz -> String Source #

IsSqlType SqlTimestamp Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTimestamp -> String Source #

IsSqlType SqlTime Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlTime -> String Source #

IsSqlType SqlText Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlText -> String Source #

IsSqlType SqlNumeric Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlNumeric -> String Source #

IsSqlType SqlInt2 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt2 -> String Source #

IsSqlType SqlInt4 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt4 -> String Source #

IsSqlType SqlInt8 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlInt8 -> String Source #

IsSqlType SqlFloat8 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlFloat8 -> String Source #

IsSqlType SqlFloat4 Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlFloat4 -> String Source #

IsSqlType SqlDate Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlDate -> String Source #

IsSqlType SqlBool Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy SqlBool -> String Source #

IsSqlType a => IsSqlType (Nullable a) Source # 
Instance details

Defined in Opaleye.Internal.PGTypes

Methods

showSqlType :: proxy (Nullable a) -> String Source #

IsRangeType a => IsSqlType (SqlRange a) Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlRange a) -> String Source #

IsSqlType a => IsSqlType (SqlArray a) Source # 
Instance details

Defined in Opaleye.Internal.PGTypesExternal

Methods

showSqlType :: proxy (SqlArray a) -> String Source #

Entire module

sqlString :: String -> Field SqlText Source #

sqlLazyByteString :: ByteString -> Field SqlBytea Source #

sqlStrictByteString :: ByteString -> Field SqlBytea Source #

sqlStrictText :: Text -> Field SqlText Source #

sqlLazyText :: Text -> Field SqlText Source #

sqlNumeric :: Scientific -> Field SqlNumeric Source #

sqlInt4 :: Int -> Field SqlInt4 Source #

sqlInt8 :: Int64 -> Field SqlInt8 Source #

sqlDouble :: Double -> Field SqlFloat8 Source #

sqlBool :: Bool -> Field SqlBool Source #

sqlUUID :: UUID -> Field SqlUuid Source #

sqlDay :: Day -> Field SqlDate Source #

sqlUTCTime :: UTCTime -> Field SqlTimestamptz Source #

sqlLocalTime :: LocalTime -> Field SqlTimestamp Source #

sqlZonedTime :: ZonedTime -> Field SqlTimestamptz Source #

sqlTimeOfDay :: TimeOfDay -> Field SqlTime Source #

sqlCiStrictText :: CI Text -> Field SqlCitext Source #

sqlCiLazyText :: CI Text -> Field SqlCitext Source #

sqlJSON :: String -> Field SqlJson Source #

sqlStrictJSON :: ByteString -> Field SqlJson Source #

sqlLazyJSON :: ByteString -> Field SqlJson Source #

sqlValueJSON :: ToJSON a => a -> Field SqlJson Source #

sqlJSONB :: String -> Field SqlJsonb Source #

sqlStrictJSONB :: ByteString -> Field SqlJsonb Source #

sqlLazyJSONB :: ByteString -> Field SqlJsonb Source #

sqlValueJSONB :: ToJSON a => a -> Field SqlJsonb Source #

sqlArray :: IsSqlType b => (a -> Field b) -> [a] -> Field (SqlArray b) Source #

sqlRange :: IsRangeType b => (a -> Field b) -> RangeBound a -> RangeBound a -> Field (SqlRange b) Source #