Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CAST(row_value AS row(some_field field_type, other_field, field_type, ...))
- presto> SELECT r.afield, r.bfield, r.cfield
- -> FROM (
- -> SELECT max_by(CAST((x1, x2, x3) AS row(afield integer, bfield varchar, cfield double)), y) r
- -> FROM (VALUES (1, 42, 'a', 13e0), (2, 40, 'b', 77e0)) t(y, x1, x2, x3)
- -> );
- afield | bfield | cfield
- --------+--------+--------
- 40 | b | 77.0
- (1 row)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement