/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/cube/expected/cube_sci.out
105 строк
1 KB
Andrew Gierth
Change floating-point output format for improved performance.
13 фев 2019, 18:20
13 фев 2019, 18:20
02ddd49
Код
Авторство
О чём код?
--- --- Testing cube output in scientific notation. This was put into separate --- test, because has platform-depending output. --- SELECT '1e27'::cube AS cube; cube --------- (1e+27) (1 row) SELECT '-1e27'::cube AS cube; cube ---------- (-1e+27) (1 row) SELECT '1.0e27'::cube AS cube; cube --------- (1e+27) (1 row) SELECT '-1.0e27'::cube AS cube; cube ---------- (-1e+27) (1 row) SELECT '1e+27'::cube AS cube; cube --------- (1e+27) (1 row) SELECT '-1e+27'::cube AS cube; cube ---------- (-1e+27) (1 row) SELECT '1.0e+27'::cube AS cube; cube --------- (1e+27) (1 row) SELECT '-1.0e+27'::cube AS cube; cube ---------- (-1e+27) (1 row) SELECT '1e-7'::cube AS cube; cube --------- (1e-07) (1 row) SELECT '-1e-7'::cube AS cube; cube ---------- (-1e-07) (1 row) SELECT '1.0e-7'::cube AS cube; cube --------- (1e-07) (1 row) SELECT '-1.0e-7'::cube AS cube; cube ---------- (-1e-07) (1 row) SELECT '1e-300'::cube AS cube; cube ---------- (1e-300) (1 row) SELECT '-1e-300'::cube AS cube; cube ----------- (-1e-300) (1 row) SELECT '1234567890123456'::cube AS cube; cube ------------------------- (1.234567890123456e+15) (1 row) SELECT '+1234567890123456'::cube AS cube; cube ------------------------- (1.234567890123456e+15) (1 row) SELECT '-1234567890123456'::cube AS cube; cube -------------------------- (-1.234567890123456e+15) (1 row)