| Copyright | (c) Soostone Inc 2020 |
|---|---|
| License | AllRightsReserved |
| Maintainer | Ozgun Ataman |
| Stability | experimental |
| Portability | POSIX |
| Safe Haskell | Safe-Inferred |
| Language | GHC2021 |
Napkin.Untyped.Ops.Sqlite
Description
Implements functions defined on https://www.sqlite.org/lang_corefunc.html
Synopsis
- type UFunc = SExp -> SExp
- type BinFunc = SExp -> SExp -> SExp
- type NulFunc = SExp
- type MulFunc = [SExp] -> SExp
- changes :: NulFunc
- char :: MulFunc
- glob :: BinFunc
- hex :: UFunc
- ifnull :: BinFunc
- iif :: MulFunc
- instr :: BinFunc
- lastInsertRowId :: NulFunc
- length :: UFunc
- like :: MulFunc
- ilike :: SExp -> SrcLitStr -> SExp
- lower :: UFunc
- ltrim :: UFunc
- nullif :: BinFunc
- random :: NulFunc
- replace :: MulFunc
- round :: UFunc
- rtrim :: MulFunc
- soundex :: UFunc
- sqliteVersion :: NulFunc
- substr :: MulFunc
- totalChanges :: NulFunc
- trim :: MulFunc
- upper :: UFunc
- windowFn :: Ref Function -> [SExp] -> WOver -> SExp
- kWindowFn :: String -> [SExp] -> WOver -> SExp
- current_date :: SExp
- date :: MulFunc
- time :: MulFunc
- datetime :: MulFunc
- julianday :: MulFunc
- strftime :: MulFunc
- group_concat :: MulFunc
- total :: UFunc
- row_number :: NulFunc
- rank :: NulFunc
- dense_rank :: NulFunc
- percent_rank :: NulFunc
- cume_dist :: NulFunc
- lag :: MulFunc
- lead :: MulFunc
- first_value :: UFunc
- last_value :: UFunc
- nth_value :: BinFunc
- between :: SExp -> SExp -> SExp -> SExp
Documentation
totalChanges :: NulFunc #
current_date :: SExp #
group_concat :: MulFunc #
row_number :: NulFunc #
dense_rank :: NulFunc #
percent_rank :: NulFunc #
first_value :: UFunc #
last_value :: UFunc #