1234567891011121314151617 |
- /* postgres can not */
- use plato;
- select row, -i64, +i64, abs(i64)
- from BigDates
- order by row;
- select min(d32), min(dt64), min(ts64), min(i64)
- , max(d32), max(dt64), max(ts64), max(i64)
- from BigDates;
- select l.row, r.row
- , 1, l.d32 - r.i64, l.dt64 - r.i64, l.ts64 - r.i64, l.i64 - r.i64
- , 2, l.d32 + r.i64, l.dt64 + r.i64, l.ts64 + r.i64, l.i64 + r.i64
- from BigDates as l cross join BigDates as r
- where abs(l.row) <= 7 and abs(r.row) <= 7
- order by l.row, r.row;
|