table_arithmetic.sql 465 B

1234567891011121314151617
  1. /* postgres can not */
  2. use plato;
  3. select row, -i64, +i64, abs(i64)
  4. from BigDates
  5. order by row;
  6. select min(d32), min(dt64), min(ts64), min(i64)
  7. , max(d32), max(dt64), max(ts64), max(i64)
  8. from BigDates;
  9. select l.row, r.row
  10. , 1, l.d32 - r.i64, l.dt64 - r.i64, l.ts64 - r.i64, l.i64 - r.i64
  11. , 2, l.d32 + r.i64, l.dt64 + r.i64, l.ts64 + r.i64, l.i64 + r.i64
  12. from BigDates as l cross join BigDates as r
  13. where abs(l.row) <= 7 and abs(r.row) <= 7
  14. order by l.row, r.row;