Hoogle Search

Within LTS Haskell 24.39 (ghc-9.10.3)

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

Exact lookup

1. flattenMaybe :: ProjectableMaybe p => p (Maybe (Maybe a)) -> p (Maybe a)

   relational-schemas	Database.Custom.SQLServer

   Compose nested Maybe phantom type on record.

2. flattenPiMaybe :: (PersistableWidth a, ProjectableFlattenMaybe (Maybe b) c) => Record cont (Maybe a) -> Pi a b -> Record cont c

   relational-schemas	Database.Custom.SQLServer

   Get narrower record with flatten leaf phantom Maybe types along with projection path.

3. fromIntegralMaybe :: (SqlContext c, Integral a, Num b) => Record c (Maybe a) -> Record c (Maybe b)

   relational-schemas	Database.Custom.SQLServer

   Number fromIntegral uni-operator.

4. fromMaybe :: (OperatorContext c, HasColumnConstraint NotNull r) => Record c r -> Record c (Maybe r) -> Record c r

   relational-schemas	Database.Custom.SQLServer

   Operator from maybe type using record extended isNull.

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

   relational-schemas	Database.Custom.SQLServer

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

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

   relational-schemas	Database.Custom.SQLServer

   String-compare operator corresponding SQL LIKE .

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

   relational-schemas	Database.Custom.SQLServer

   Aggregation function MAX.

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

   relational-schemas	Database.Custom.SQLServer

   Aggregation function MIN.

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

   relational-schemas	Database.Custom.SQLServer

   Number negate uni-operator corresponding SQL -.

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

    relational-schemas	Database.Custom.SQLServer

    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
    

Page 315 of many | Previous | Next