DDSQL Editor Data Types (Preview)
Cette page n'est pas encore disponible en français, sa traduction est en cours.
Si vous avez des questions ou des retours sur notre projet de traduction actuel,
n'hésitez pas à nous contacter.
Data types
DDSQL implements a simplified version of the SQL type system that is mostly descended from PostgreSQL.
Base types
| SQL name | Aliases | Description |
|---|
| integer | int | Storage is always int64. |
| text | char, varchar, string | Storage is always an unlimited length UTF-8. |
| real | double, decimal | Storage is always IEEE-754 float64. |
| timestamp | timestamp without time zone | SQL standard datetime type. |
| date | | Timestamp with resolution on a day level. |
| interval | | Duration of time. |
| group | hstore, tag_column | Sorted set of strings with tag-like “= is contains” semantics. |
| boolean | | TRUE or FALSE |
| json | | JSON data |
Arrays
Arrays are an ordered collection of a specific base type. Each base type can have a corresponding array type.
Literals
The table below contains examples on how to declare literals for each type, for use in expressions like SELECT <LITERAL> or in comparisons like WHERE timestamp > timestamp '1 hr ago'.
| Name | Example |
|---|
| integer | 1, 4, 23901239412, 0x4B1D |
| text | 'Hello, world' |
| real | 1.0, 1e30, 314e-2, .25, 5. |
| date | date <DATE_STRING> (where DATE_STRING is a string that can be parsed into a date, or a relative string like 1 day ago') |
| timestamp | timestamp <TIMESTAMP_STRING> (where TIMESTAMP_STRING is a string that can be parsed into a timestamp, or a relative string like '1 day ago', 'now') |
| interval | interval <INTERVAL> (where INTERVAL is a string that can be parsed into a interval, like 1 day, 30s, 2 min') |
| arrays | array<type>[values...] |
