table_arithmetic_mul_div.sql 1.0 KB

1234567891011121314151617181920212223242526272829303132333435
  1. /* postgres can not */
  2. use plato;
  3. select l.row, r.row
  4. , 1, l.i64*i8, l.i64*i16, l.i64*i32, l.i64*r.i64
  5. , 2, i8*l.i64, i16*l.i64, i32*l.i64, r.i64*l.i64
  6. , 3, l.i64/i8, l.i64/i16, l.i64/i32, l.i64/r.i64
  7. from BigDates as l cross join Signed as r
  8. where abs(l.row) <= 7 and abs(r.row) <= 7
  9. order by l.row, r.row;
  10. select l.row, r.row
  11. , 1, i64*ui8, i64*ui16, i64*ui32, i64*ui64
  12. , 2, ui8*i64, ui16*i64, ui32*i64, ui64*i64
  13. , 3, i64/ui8, i64/ui16, i64/ui32, i64/ui64
  14. from BigDates as l cross join Unsigned as r
  15. where abs(l.row) <= 7 and abs(r.row) <= 7
  16. order by l.row, r.row;
  17. select l.row, r.row
  18. , 1, l.i*i8, l.i*i16, l.i*i32, l.i*r.i64
  19. , 2, i8*l.i, i16*l.i, i32*l.i, r.i64*l.i
  20. , 3, l.i/i8, l.i/i16, l.i/i32, l.i/r.i64
  21. from NarrowInterval as l cross join Signed as r
  22. where abs(l.row) <= 7 and abs(r.row) <= 7
  23. order by l.row, r.row;
  24. select l.row, r.row
  25. , 1, i*ui8, i*ui16, i*ui32, i*ui64
  26. , 2, ui8*i, ui16*i, ui32*i, ui64*i
  27. , 3, i/ui8, i/ui16, i/ui32, i/ui64
  28. from NarrowInterval as l cross join Unsigned as r
  29. where abs(l.row) <= 7 and abs(r.row) <= 7
  30. order by l.row, r.row;