1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
/* 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;
|
