Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Unstructured Datatypes in Postgres – Hstore vs. JSON vs. JSONB. Parent comment
If the datetimes are ISO formatted strings, would regex matching not work for basic filtering?
where json_field.datetime similar to '2016-07-.*'
There are no comments on this comment yet.
If the datetimes are ISO formatted strings, would regex matching not work for basic filtering?
Of course, it'll probably be slow-tastic, and less convenient than native datetime manipulation, but hey, maybe it's enough to get unblocked?