Reference
The reference defines CoordinatorDB's implemented public contracts. Use it for exact syntax, argument and value ranges, result layouts, setting scope and permanent error identifiers.
Find a contract
- SQL ReferenceWrite identifiers, literals, expressions, statement batches and control statements.
- Data TypesChoose native types, declare value constraints and convert SQL values.
- FunctionsScalar, aggregate, table and window functions in CoordinatorDB.
- FormatsSupported input and output formats in CoordinatorDB.
- SettingsDatabase, format and server options in CoordinatorDB.
- System TablesCoordinatorDB server catalogs and request observations.
See also SQL statements, operators and error codes.
Reading examples
SQL examples with FORMAT use a server interface. The embedded Connection API returns typed rows directly. Format input consumes the remaining request as data, so run the later verification query as a separate request.
Examples create their own small fixtures. Use the stated schema and source-file prerequisites, and choose fresh sample table names when running several guides in one database.