opaleye-0.4.0.0: An SQL-generating DSL targeting PostgreSQL

Safe HaskellNone
LanguageHaskell98

Opaleye.Operators

Synopsis

Documentation

restrict :: QueryArr (Column PGBool) () Source

Restrict query results to a particular condition. Corresponds to the guard method of the MonadPlus class.

doubleOfInt :: Column PGInt4 -> Column PGFloat8 Source

(.==) :: Column a -> Column a -> Column PGBool infix 4 Source

(./=) :: Column a -> Column a -> Column PGBool infix 4 Source

(.>) :: PGOrd a => Column a -> Column a -> Column PGBool infix 4 Source

(.<) :: PGOrd a => Column a -> Column a -> Column PGBool infix 4 Source

(.<=) :: PGOrd a => Column a -> Column a -> Column PGBool infix 4 Source

(.>=) :: PGOrd a => Column a -> Column a -> Column PGBool infix 4 Source

case_ :: [(Column PGBool, Column a)] -> Column a -> Column a Source

ifThenElse :: Column PGBool -> Column a -> Column a -> Column a Source

(.&&) :: Column PGBool -> Column PGBool -> Column PGBool infixr 3 Source

(.||) :: Column PGBool -> Column PGBool -> Column PGBool infixr 2 Source

not :: Column PGBool -> Column PGBool Source

(.++) :: Column PGText -> Column PGText -> Column PGText Source

lower :: Column PGText -> Column PGText Source

upper :: Column PGText -> Column PGText Source

like :: Column PGText -> Column PGText -> Column PGBool Source

ors :: Foldable f => f (Column PGBool) -> Column PGBool Source

in_ :: (Functor f, Foldable f) => f (Column a) -> Column a -> Column PGBool Source