work_with_subquery.sql

* | select
    preds[1] as unixtime,
    preds[3] as predict
from (
    select
        ts_predicate_ar(timestamp, value, 2, 10) as p
    from log
), unnest(p) as t(preds)