tuple_nth.sql 317 B

12345678910111213141516
  1. USE plato;
  2. insert into @tmp
  3. SELECT
  4. key,
  5. (subkey,key) as a,
  6. (1,key) as b,
  7. Just((subkey,key)) as c,
  8. Just((Just(subkey),key)) as d,
  9. Nothing(Tuple<Int32,Int32>?) as e,
  10. Nothing(Tuple<Int32?,Int32>?) as f,
  11. FROM Input;
  12. commit;
  13. select a.0,a.1,b.0,b.1,c.0,c.1,d.0,d.1,e.0,e.1,f.0,f.1 from @tmp;