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.

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

    relational-schemas Database.Custom.SQLite3

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

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

    relational-schemas Database.Custom.SQLite3

    Number fromIntegral uni-operator.

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

    relational-schemas Database.Custom.SQLite3

    Operator from maybe type using record extended isNull.

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

    relational-schemas Database.Custom.SQLite3

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

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

    relational-schemas Database.Custom.SQLite3

    String-compare operator corresponding SQL LIKE .

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

    relational-schemas Database.Custom.SQLite3

    Aggregation function MAX.

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

    relational-schemas Database.Custom.SQLite3

    Aggregation function MIN.

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

    relational-schemas Database.Custom.SQLite3

    Number negate uni-operator corresponding SQL -.

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

    relational-schemas Database.Custom.SQLite3

    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
    

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

    relational-schemas Database.Custom.SQLite3

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

Page 317 of many | Previous | Next