Guest User

Untitled

a guest
Jan 17th, 2019
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. SELECT
  2. R."ID",
  3. CAST(F."Features"->>'Start' AS INT) AS Start,
  4. CAST(F."Features"->>'End' AS INT) AS End,
  5. sort_desc((array(select json_array_elements(R."Data")))[CAST(F."Features"->>'Start' AS INT):CAST(F."Features"->>'End' AS INT)])[1] as maxData,
  6. (array(select json_array_elements(R."Data")))[CAST(F."Features"->>'Start' AS INT):CAST(F."Features"->>'End' AS INT)] as Data
  7. FROM
  8. raw AS R
  9. INNER JOIN
  10. features AS F ON R."ID" = F."ID"
Add Comment
Please, Sign In to add comment