Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- R."ID",
- CAST(F."Features"->>'Start' AS INT) AS Start,
- CAST(F."Features"->>'End' AS INT) AS End,
- sort_desc((array(select json_array_elements(R."Data")))[CAST(F."Features"->>'Start' AS INT):CAST(F."Features"->>'End' AS INT)])[1] as maxData,
- (array(select json_array_elements(R."Data")))[CAST(F."Features"->>'Start' AS INT):CAST(F."Features"->>'End' AS INT)] as Data
- FROM
- raw AS R
- INNER JOIN
- features AS F ON R."ID" = F."ID"
Add Comment
Please, Sign In to add comment