| Safe Haskell | None |
|---|---|
| Language | Haskell2010 |
Opaleye.PGTypes
Description
Postgres types and functions to create Columns of those types.
You may find it more convenient to use Opaleye.Constant instead.
- pgString :: String -> Column PGText
- pgLazyByteString :: ByteString -> Column PGBytea
- pgStrictByteString :: ByteString -> Column PGBytea
- pgStrictText :: Text -> Column PGText
- pgLazyText :: Text -> Column PGText
- 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
- pgTimeOfDay :: TimeOfDay -> Column PGTime
- pgCiStrictText :: CI Text -> Column PGCitext
- pgCiLazyText :: CI Text -> Column PGCitext
- pgJSON :: String -> Column PGJson
- pgStrictJSON :: ByteString -> Column PGJson
- pgLazyJSON :: ByteString -> Column PGJson
- pgValueJSON :: ToJSON a => a -> Column PGJson
- pgJSONB :: String -> Column PGJsonb
- pgStrictJSONB :: ByteString -> Column PGJsonb
- pgLazyJSONB :: ByteString -> Column PGJsonb
- pgValueJSONB :: ToJSON a => a -> Column PGJsonb
- pgArray :: forall a b. IsSqlType b => (a -> Column b) -> [a] -> Column (PGArray b)
- class IsSqlType pgType where
- data PGBool
- data PGDate
- data PGFloat4
- data PGFloat8
- data PGInt8
- data PGInt4
- data PGInt2
- data PGNumeric
- data PGText
- data PGTime
- data PGTimestamp
- data PGTimestamptz
- data PGUuid
- data PGCitext
- data PGArray a
- data PGBytea
- data PGJson
- data PGJsonb
- literalColumn :: Literal -> Column a
- unsafePgFormatTime :: FormatTime t => Name -> String -> t -> Column c
Documentation
Creating SQL values
pgLocalTime :: LocalTime -> Column PGTimestamp Source #
pgStrictJSON :: ByteString -> Column PGJson Source #
pgLazyJSON :: ByteString -> Column PGJson Source #
pgStrictJSONB :: ByteString -> Column PGJsonb Source #
pgLazyJSONB :: ByteString -> Column PGJsonb Source #
class IsSqlType pgType where Source #
Minimal complete definition
Methods
showPGType :: proxy pgType -> String Source #
Instances
SQL datatypes
Instances
Instances
data PGTimestamp Source #
data PGTimestamptz Source #
Deprecated functions
literalColumn :: Literal -> Column a Source #
Warning: literalColumn has been moved to Opaleye.Internal.PGTypes and will be deprecated in version 0.6
unsafePgFormatTime :: FormatTime t => Name -> String -> t -> Column c Source #
Warning: unsafePgFormatTime has been moved to Opaleye.Internal.PGTypes and will be deprecated in version 0.6