12345678910 |
- /* postgres can not */
- use plato;
- select l.row, r.row
- , 1, l.d32 - r.d32, l.d32 - r.dt64, l.d32 - r.ts64
- , 2, l.dt64 - r.d32, l.dt64 - r.dt64, l.dt64 - r.ts64
- , 3, l.ts64 - r.d32, l.ts64 - r.dt64, l.ts64 - r.ts64
- 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;
|