Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. CAST(row_value AS row(some_field field_type, other_field, field_type, ...))
  2.  
  3. presto> SELECT r.afield, r.bfield, r.cfield
  4. -> FROM (
  5. -> SELECT max_by(CAST((x1, x2, x3) AS row(afield integer, bfield varchar, cfield double)), y) r
  6. -> FROM (VALUES (1, 42, 'a', 13e0), (2, 40, 'b', 77e0)) t(y, x1, x2, x3)
  7. -> );
  8. afield | bfield | cfield
  9. --------+--------+--------
  10. 40 | b | 77.0
  11. (1 row)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement