The supported types are:
- 2.integer: a 64-bit signed integer
- 3.real: a 64-bit floating point number
- 4.text: An UTF-8 text string
- 5.blob: Binary data
BLOBdata can be accessed in sync rules, but cannot be synced directly to clients, and cannot be used as bucket parameters.
Postgres values are mapped according to this table:
There is no dedicated boolean data type. Boolean values are represented as 1 (true) or 0 (false).
jsonbvalues are treated as
textvalues in their serialized representation. JSON functions and operators operate directly on these