search

metadb-project / metadb

Metadb extends PostgreSQL with features to support analytics such as streaming data sources, data model transforms, and historical data
Apache License 2.0
8 stars 2 forks source link

Improve timestamp type matching in JSON transform #68

Open nassibnassar opened 3 months ago

nassibnassar commented 3 months ago

The JSON transform calls command.InferTypeFromString() which recognizes timestamptz and timestamp types using regular expressions. The timestamptz regular expression does not allow for the fractional time zone part of:

2009-01-07T23:59:59-07:00

The regular expression should be extended to support this, or another approach found.