Non-Mathesar types are database types that don’t have any special functionality within Mathesar. This could be because that functionality is not implemented, yet it’s a standard Postgres type (Other), or because it’s a custom data type and not included in standard Postgres data types (Custom).
‘Non-Mathesar’ data type can be edited or added, but there are no particular data input or display features.
Non-Mathesar Data Type Prototype
Users cannot set ‘Non-Mathesar’ data types. Mathesar can only add these by connecting to an existing database.
Users can edit the existing values of a ‘Non-Mathesar’ data type column as they would with text string types.
Users can filter the existing values of a ‘Non-Mathesar’ data type column as they would with text string types.
Users can group the existing values of a ‘Non-Mathesar’ data type column as they would with text string types.
As part of the implementation of data types, we need to consider how the table will display content such as a JSON document or other longer content formats.