Types and casting rules
Relational supports the following types:
str int float None Rdate. The Rdate type is specific to relational.
Strings in the format
YYYY-MM-DD can be casted as Rdate.
Automatic casting and csv files
When loading csv files or editing a relation from the GUI, relational will perform automatic casting.
The casting is column based, so if a column contains only numbers, they will all be cast as
int. If there is a string value in the column, they will all be considered
If a column contains all values in the format
YYYY-MM-DD they will all be converted to Rdate.
Some queries return
None (the Python equivalent of
None value can't be stored in csv files. When reloading it will just be a
To properly save a relation keeping the types, use the json format.
The json format keeps type information, so no casting is performed.