Hoogle Search

Within LTS Haskell 24.46 (ghc-9.10.3)

Note that Stackage only displays results for the latest LTS and Nightly snapshot. Learn more.

Exact lookup

1. likeMaybe :: (OperatorContext c, IsString a, LiteralSQL a) => Record c (Maybe a) -> a -> Record c (Maybe Bool)

   relational-schemas	Database.Custom.IBMDB2

   String-compare operator corresponding SQL LIKE . Maybe type version.

2. likeMaybe' :: (OperatorContext c, IsString a) => Record c (Maybe a) -> Record c (Maybe a) -> Record c (Maybe Bool)

   relational-schemas	Database.Custom.IBMDB2

   String-compare operator corresponding SQL LIKE .

3. maxMaybe :: (Ord a, AggregatedContext ac, SqlContext ac) => Record Flat (Maybe a) -> Record ac (Maybe a)

   relational-schemas	Database.Custom.IBMDB2

   Aggregation function MAX.

4. minMaybe :: (Ord a, AggregatedContext ac, SqlContext ac) => Record Flat (Maybe a) -> Record ac (Maybe a)

   relational-schemas	Database.Custom.IBMDB2

   Aggregation function MIN.

5. negateMaybe :: (OperatorContext c, Num a) => Record c (Maybe a) -> Record c (Maybe a)

   relational-schemas	Database.Custom.IBMDB2

   Number negate uni-operator corresponding SQL -.

6. queryMaybe :: (MonadQualify ConfigureQuery m, MonadQuery m) => Relation () r -> m (Record Flat (Maybe r))

   relational-schemas	Database.Custom.IBMDB2

   Join sub-query. Query result is Maybe. The combinations of query and queryMaybe express inner joins, left outer joins, right outer joins, and full outer joins. Here is an example of a right outer join:

   outerJoin = relation $ do
   e <- queryMaybe employee
   d <- query department
   on $ e ?! E.deptId' .=. just (d ! D.deptId')
   return $ (,) |$| e |*| d
   

7. queryMaybe' :: MonadQuery m => Relation p r -> m (PlaceHolders p, Record Flat (Maybe r))

   relational-schemas	Database.Custom.IBMDB2

   Join sub-query with place-holder parameter p. Query result is Maybe.

8. showNumMaybe :: (SqlContext c, Num a, IsString b) => Record c (Maybe a) -> Record c (Maybe b)

   relational-schemas	Database.Custom.IBMDB2

   Unsafely show number into string-like type in records.

9. sumMaybe :: (Num a, AggregatedContext ac, SqlContext ac) => Record Flat (Maybe a) -> Record ac (Maybe a)

   relational-schemas	Database.Custom.IBMDB2

   Aggregation function SUM.

10. uniqueQueryMaybe' :: UniqueRelation p c r -> QueryUnique (PlaceHolders p, Record c (Maybe r))

    relational-schemas	Database.Custom.IBMDB2

    Join unique sub-query with place-holder parameter p. Query result is Maybe.

Page 312 of many | Previous | Next