File: 125_numeric_literals.sql

package info (click to toggle)
sqlfmt 0.29.0-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 1,580 kB
  • sloc: python: 10,007; sql: 5,626; makefile: 39
file content (28 lines) | stat: -rw-r--r-- 470 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
 
select 1, 1.0, +1, +1.0, -1, -1.0, 1e9, 1e+9, 1e-9, -1e9, -1e+9, +1e-9, -1e-9, 1.6e9, 1.6e-9, 1., 1.e9, 1.e-9, -1., -1.e-9, 0xFF, 0b000111, 0O2112, 1_000_000, 3.141_592_6
)))))__SQLFMT_OUTPUT__(((((
select
    1,
    1.0,
    +1,
    +1.0,
    -1,
    -1.0,
    1e9,
    1e+9,
    1e-9,
    -1e9,
    -1e+9,
    +1e-9,
    -1e-9,
    1.6e9,
    1.6e-9,
    1.,
    1.e9,
    1.e-9,
    -1.,
    -1.e-9,
    0xff,
    0b000111,
    0o2112,
    1_000_000,
    3.141_592_6