complex_scalars.sql 270 B

123456789101112
  1. USE plato;
  2. select
  3. subkey || key as k,
  4. Just(Just(1)) as nested_opt,
  5. Just(1p) as opt_pg,
  6. Just(Just(1p)) as nested_opt_pg,
  7. 2p as pg,
  8. AsTuple(1, 2, Just(Just(2))) as tuple,
  9. Just(Just(Just(AsTuple(1, 2, Just(Just(2)))))) as double_tuple
  10. from Input
  11. order by k;