Skip to content

Instantly share code, notes, and snippets.

@marufeuille

marufeuille/work_with_subquery.sql

Created January 28, 2020 04:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save marufeuille/c9d3a24b3b5ab72379695ffb5ef51ff7 to your computer and use it in GitHub Desktop.
Save marufeuille/c9d3a24b3b5ab72379695ffb5ef51ff7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment