GitHub Blog Community Support

The Fauna service will be ending on May 30, 2025.

For more information on the service wind down, see our announcement and the Fauna Service End-of-Life FAQ.

Fauna version:
- current
- v4

- Welcome
- Learn
  - Introduction
  - Quick start
    - Dashboard
    - Client application
  - Understanding Fauna
  - Sample apps
    - Fwitter
  - Tutorials
  - Cookbook
    - Collections
      - Create
      - Create a document
      - Create many documents
      - Delete
      - Get
      - List
      - Metadata
      - Rename
    - Databases
      - Create
      - Delete
      - Get
      - List
      - Metadata
      - Rename
    - Documents
      - Reference
      - Create
      - Create many
      - Upsert
    - Functions
      - Call
      - Create
      - Delete
      - Get
      - List
      - Metadata
      - Rename
    - Indexes
      - Create
      - Delete
      - Get
      - List
      - Query
      - Metadata
      - Rename
    - Keys
      - Create
      - Delete
      - Get
      - List
      - Metadata
    - Tokens
      - Create
      - Delete
      - Get
      - List
      - Metadata
    - Array
      - Zip together two arrays
    - Math
      - Unsigned integer subtraction
    - Search
    - Strings
      - Split a string by a delimiter
- Build
- API references
  - FQL
    - FQL cheat sheet
    - Indexes
    - Deprecations
    - Known issues
    - Built-in functions
      - Abort
      - Abs
      - AccessProvider
      - AccessProviders
      - Acos
      - Add
      - All
      - And
      - Any
      - Append
      - Asin
      - At
      - Atan
      - BitAnd
      - BitNot
      - BitOr
      - BitXor
      - Call
      - Casefold
      - Ceil
      - Class
      - Classes
      - Collection
      - Collections
      - Concat
      - Contains
      - ContainsField
      - ContainsPath
      - ContainsStr
      - ContainsStrRegex
      - ContainsValue
      - Cos
      - Cosh
      - Count
      - Create
      - CreateAccessProvider
      - CreateClass
      - CreateCollection
      - CreateDatabase
      - CreateFunction
      - CreateIndex
      - CreateKey
      - CreateRole
      - Credentials
      - CurrentIdentity
      - CurrentToken
      - Database
      - Databases
      - Date
      - DayOfMonth
      - DayOfWeek
      - DayOfYear
      - Degrees
      - Delete
      - Difference
      - Distinct
      - Divide
      - Do
      - Documents
      - Drop
      - EndsWith
      - Epoch
      - Equals
      - Events
      - Exists
      - Exp
      - Filter
      - FindStr
      - FindStrRegex
      - Floor
      - Foreach
      - Format
      - Function
      - Functions
      - GT
      - GTE
      - Get
      - HasCurrentIdentity
      - HasIdentity
      - HasCurrentToken
      - Hour
      - Hypot
      - Identify
      - Identity
      - If
      - Index
      - Indexes
      - Insert
      - Intersection
      - IsArray
      - IsBoolean
      - IsBytes
      - IsCollection
      - IsCredentials
      - IsDatabase
      - IsDate
      - IsDoc
      - IsDouble
      - IsEmpty
      - IsFunction
      - IsIndex
      - IsInteger
      - IsKey
      - IsLambda
      - IsNonEmpty
      - IsNull
      - IsNumber
      - IsObject
      - IsRef
      - IsRole
      - IsSet
      - IsString
      - IsTimestamp
      - IsToken
      - Join
      - KeyFromSecret
      - Keys
      - LT
      - LTE
      - LTrim
      - Lambda
      - Length
      - Let
      - Ln
      - Log
      - Login
      - Logout
      - LowerCase
      - Map
      - Match
      - Max
      - Mean
      - Merge
      - Min
      - Minute
      - Modulo
      - Month
      - MoveDatabase
      - Multiply
      - NewId
      - Not
      - Now
      - Or
      - Paginate
      - Pow
      - Prepend
      - Query
      - RTrim
      - Radians
      - Range
      - Reduce
      - Ref
      - RegexEscape
      - Remove
      - Repeat
      - Replace
      - ReplaceStr
      - ReplaceStrRegex
      - Reverse
      - Role
      - Roles
      - Round
      - Second
      - Select
      - SelectAll
      - Sign
      - Sin
      - Singleton
      - Sinh
      - Space
      - Sqrt
      - StartsWith
      - SubString
      - Subtract
      - Sum
      - Take
      - Tan
      - Tanh
      - Time
      - TimeAdd
      - TimeDiff
      - TimeSubtract
      - TitleCase
      - ToArray
      - ToDate
      - ToDouble
      - ToInteger
      - ToMicros
      - ToMillis
      - ToNumber
      - ToObject
      - ToSeconds
      - ToString
      - ToTime
      - Tokens
      - Trim
      - Trunc
      - Union
      - Update
      - UpperCase
      - Var
      - Year
- Drivers
  - Version strategy
  - Imports
  - Connections
  - C#
  - Go
  - JVM (Java, Scala)
  - JavaScript
  - Python
  - Known issues
- Security
- References
  - Glossary

Learn
Cookbook
Math

Math recipes

This section contains solutions to common math problems that can be solved with FQL:

Unsigned integer subtraction

Zip together two arrays Unsigned integer subtraction

Copyright © 2018–2025 Fauna, Inc.

Terms of use Privacy Policy ↑

\