Use an expression for time column (e.g., for time stored in JSON blob)

[dreamtheater0]

Is it possible to modify timescaledb to use an expression for the time column?

[RobAtticus]

Can you clarify what you mean by using an expression?

[dreamtheater0]

I mean that when make a hypertable one can use a Postgres' expression like the following:

SELECT create_hypertable('(conditions', 'json_attr->'time')::int8');

If the time values are stored in a json type column, we need this.

[RobAtticus]

Currently you cannot. Time must be stored as a column either using an int datatype or a timestamp datatype.

Further, not sure where support for that would fit on our roadmap, but we will keep it in mind!

[mfreed]

Hi @kskim80 I believe this has been addressed with with #639 -- in that it allows you to define your own time functions -- which was part of our 1.1 release.

Closing this issue for now, feel free to re-open if doesn't solve your problems.