Safe Haskell	Safe
Language	Haskell2010

Opaleye.Internal.Column

Synopsis

Documentation

newtype Column pgType Source #

A column of a Query, of type pgType. For example Column PGInt4 is an int4 column and a Column PGText is a text column.

Do not use the Show instance of Column. It is considered deprecated and will be removed in version 0.7.

Constructors

Column PrimExpr

Instances

Default ViewColumnMaker String (Column a) #
Methods def :: ViewColumnMaker String (Column a) #
Default RelExprMaker String (Column a) #
Methods def :: RelExprMaker String (Column a) #
Default Constant Bool (Column PGBool) #
Methods def :: Constant Bool (Column PGBool) #
Default Constant Double (Column PGFloat8) #
Methods def :: Constant Double (Column PGFloat8) #
Default Constant Int (Column PGInt4) #
Methods def :: Constant Int (Column PGInt4) #
Default Constant Int32 (Column PGInt4) #
Methods def :: Constant Int32 (Column PGInt4) #
Default Constant Int64 (Column PGInt8) #
Methods def :: Constant Int64 (Column PGInt8) #
Default Constant ByteString (Column PGJsonb) #
Methods def :: Constant ByteString (Column PGJsonb) #
Default Constant ByteString (Column PGJson) #
Methods def :: Constant ByteString (Column PGJson) #
Default Constant ByteString (Column PGBytea) #
Methods def :: Constant ByteString (Column PGBytea) #
Default Constant ByteString (Column PGJsonb) #
Methods def :: Constant ByteString (Column PGJsonb) #
Default Constant ByteString (Column PGJson) #
Methods def :: Constant ByteString (Column PGJson) #
Default Constant ByteString (Column PGBytea) #
Methods def :: Constant ByteString (Column PGBytea) #
Default Constant String (Column PGText) #
Methods def :: Constant String (Column PGText) #
Default Constant Text (Column PGText) #
Methods def :: Constant Text (Column PGText) #
Default Constant UTCTime (Column PGTimestamptz) #
Methods def :: Constant UTCTime (Column PGTimestamptz) #
Default Constant Value (Column PGJsonb) #
Methods def :: Constant Value (Column PGJsonb) #
Default Constant Value (Column PGJson) #
Methods def :: Constant Value (Column PGJson) #
Default Constant Text (Column PGText) #
Methods def :: Constant Text (Column PGText) #
Default Constant ZonedTime (Column PGTimestamptz) #
Methods def :: Constant ZonedTime (Column PGTimestamptz) #
Default Constant LocalTime (Column PGTimestamp) #
Methods def :: Constant LocalTime (Column PGTimestamp) #
Default Constant TimeOfDay (Column PGTime) #
Methods def :: Constant TimeOfDay (Column PGTime) #
Default Constant Day (Column PGDate) #
Methods def :: Constant Day (Column PGDate) #
Default Constant UUID (Column PGUuid) #
Methods def :: Constant UUID (Column PGUuid) #
QueryRunnerColumnDefault a b => Default QueryRunner (Column a) b #
Methods def :: QueryRunner (Column a) b #
Default Updater (Column a) (Maybe (Column a)) #
Methods def :: Updater (Column a) (Maybe (Column a)) #
Default Updater (Column a) (Column a) #
Methods def :: Updater (Column a) (Column a) #
Default Unpackspec (Column a) (Column a) #
Methods def :: Unpackspec (Column a) (Column a) #
Default Valuesspec (Column a) (Column a) #
Methods def :: Valuesspec (Column a) (Column a) #
Default Binaryspec (Column a) (Column a) #
Methods def :: Binaryspec (Column a) (Column a) #
Default IfPP (Column a) (Column a) #
Methods def :: IfPP (Column a) (Column a) #
Default EqPP (Column a) (Column a) #
Methods def :: EqPP (Column a) (Column a) #
Default NullMaker (Column a) (Column (Nullable a)) #
Methods def :: NullMaker (Column a) (Column (Nullable a)) #
Default NullMaker (Column (Nullable a)) (Column (Nullable a)) #
Methods def :: NullMaker (Column (Nullable a)) (Column (Nullable a)) #
(Default Constant a (Column b), IsSqlType b) => Default Constant [a] (Column (PGArray b)) #
Methods def :: Constant [a] (Column (PGArray b)) #
Default Constant haskell (Column sql) => Default Constant (Maybe haskell) (Maybe (Column sql)) #
Methods def :: Constant (Maybe haskell) (Maybe (Column sql)) #
Default Constant haskell (Column sql) => Default Constant (Maybe haskell) (Column (Nullable sql)) #
Methods def :: Constant (Maybe haskell) (Column (Nullable sql)) #
Default Constant (CI Text) (Column PGCitext) #
Methods def :: Constant (CI Text) (Column PGCitext) #
Default Constant (CI Text) (Column PGCitext) #
Methods def :: Constant (CI Text) (Column PGCitext) #
Default Constant (PGRange Int) (Column (PGRange PGInt4)) #
Methods def :: Constant (PGRange Int) (Column (PGRange PGInt4)) #
Default Constant (PGRange Int64) (Column (PGRange PGInt8)) #
Methods def :: Constant (PGRange Int64) (Column (PGRange PGInt8)) #
Default Constant (PGRange UTCTime) (Column (PGRange PGTimestamptz)) #
Methods def :: Constant (PGRange UTCTime) (Column (PGRange PGTimestamptz)) #
Default Constant (PGRange LocalTime) (Column (PGRange PGTimestamp)) #
Methods def :: Constant (PGRange LocalTime) (Column (PGRange PGTimestamp)) #
Default Constant (PGRange Day) (Column (PGRange PGDate)) #
Methods def :: Constant (PGRange Day) (Column (PGRange PGDate)) #
Default Distinctspec (Column a) (Column a) #
Methods def :: Distinctspec (Column a) (Column a) #
(PGNum a, PGFractional a) => Fractional (Column a) Source #
Methods (/) :: Column a -> Column a -> Column a # recip :: Column a -> Column a # fromRational :: Rational -> Column a #
PGNum a => Num (Column a) Source #
Methods (+) :: Column a -> Column a -> Column a # (-) :: Column a -> Column a -> Column a # (*) :: Column a -> Column a -> Column a # negate :: Column a -> Column a # abs :: Column a -> Column a # signum :: Column a -> Column a # fromInteger :: Integer -> Column a #
Show (Column pgType) Source #
Methods showsPrec :: Int -> Column pgType -> ShowS # show :: Column pgType -> String # showList :: [Column pgType] -> ShowS #
PGString a => IsString (Column a) Source #
Methods fromString :: String -> Column a #
TableColumn (Maybe (Column a)) a Source #
Methods tableColumn :: String -> TableColumns (Maybe (Column a)) (Column a) Source #
TableColumn (Column a) a Source #
Methods tableColumn :: String -> TableColumns (Column a) (Column a) Source #

data Nullable a Source #

Only used within a Column, to indicate that it can be NULL. For example, a Column (Nullable PGText) can be NULL but a Column PGText cannot.

Constructors

Nullable

Instances

Default NullMaker (Column a) (Column (Nullable a)) #
Methods def :: NullMaker (Column a) (Column (Nullable a)) #
Default NullMaker (Column (Nullable a)) (Column (Nullable a)) #
Methods def :: NullMaker (Column (Nullable a)) (Column (Nullable a)) #
Default Constant haskell (Column sql) => Default Constant (Maybe haskell) (Column (Nullable sql)) #
Methods def :: Constant (Maybe haskell) (Column (Nullable sql)) #
IsSqlType a => IsSqlType (Nullable a) Source #
Methods showPGType :: proxy (Nullable a) -> String Source # showSqlType :: proxy (Nullable a) -> String Source #
PGOrd a => PGOrd (Nullable a) Source #

QueryRunnerColumnDefault a b => QueryRunnerColumnDefault (Nullable a) (Maybe b) Source #
Methods queryRunnerColumnDefault :: QueryRunnerColumn (Nullable a) (Maybe b) Source #

unColumn :: Column a -> PrimExpr Source #

unsafeCoerceColumn :: Column a -> Column b Source #

Treat a Column as though it were of a different type. If such a treatment is not valid then Postgres may fail with an error at SQL run time.

unsafeCast :: String -> Column a -> Column b Source #

Cast a column to any other type. Implements Postgres's :: or CAST( ... AS ... ) operations. This is safe for some conversions, such as uuid to text.

unsafeCompositeField :: Column a -> String -> Column b Source #

binOp :: BinOp -> Column a -> Column b -> Column c Source #

unOp :: UnOp -> Column a -> Column b Source #

unsafeCase_ :: [(Column pgBool, Column a)] -> Column a -> Column a Source #

unsafeIfThenElse :: Column pgBool -> Column a -> Column a -> Column a Source #

unsafeGt :: Column a -> Column a -> Column pgBool Source #

unsafeEq :: Column a -> Column a -> Column pgBool Source #

class PGNum a where Source #

Minimal complete definition

pgFromInteger

Methods

pgFromInteger :: Integer -> Column a Source #

Instances

PGNum PGInt4 Source #
Methods pgFromInteger :: Integer -> Column PGInt4 Source #
PGNum PGInt8 Source #
Methods pgFromInteger :: Integer -> Column PGInt8 Source #
PGNum PGFloat8 Source #
Methods pgFromInteger :: Integer -> Column PGFloat8 Source #

class PGFractional a where Source #

Minimal complete definition

pgFromRational

Methods

pgFromRational :: Rational -> Column a Source #

Instances

PGFractional PGFloat8 Source #
Methods pgFromRational :: Rational -> Column PGFloat8 Source #

class PGIntegral a Source #

A dummy typeclass whose instances support integral operations.

Instances

PGIntegral PGInt2 Source #

PGIntegral PGInt4 Source #

PGIntegral PGInt8 Source #

class PGString a where Source #

Minimal complete definition

pgFromString

Methods

pgFromString :: String -> Column a Source #

Instances

PGString PGCitext Source #
Methods pgFromString :: String -> Column PGCitext Source #
PGString PGText Source #
Methods pgFromString :: String -> Column PGText Source #