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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
|
SELECT
f, meter(f), kilogram(f)
FROM
factors;
f | meter | kilogram
---------------+---------+----------
1e+33 | 1e+33 m | 1e+33 kg
1e+30 | 1 Qm | 1e+30 kg
1e+27 | 1 Rm | 1 Qg
1e+24 | 1 Ym | 1 Rg
1e+21 | 1 Zm | 1 Yg
1e+18 | 1 Em | 1 Zg
1e+15 | 1 Pm | 1 Eg
1000000000000 | 1 Tm | 1 Pg
1000000000 | 1 Gm | 1 Tg
1000000 | 1 Mm | 1 Gg
1000 | 1 km | 1 Mg
1 | 1 m | 1 kg
0.001 | 1 mm | 1 g
1e-06 | 1 µm | 1 mg
1e-09 | 1 nm | 1 µg
1e-12 | 1 pm | 1 ng
1e-15 | 1 fm | 1 pg
1e-18 | 1 am | 1 fg
1e-21 | 1 zm | 1 ag
1e-24 | 1 ym | 1 zg
1e-27 | 1 rm | 1 yg
1e-30 | 1 qm | 1 rg
1e-33 | 1e-33 m | 1 qg
1e-36 | 1e-36 m | 1e-36 kg
0 | 0 m | 0 kg
(25 rows)
SELECT
p, (p||'m/m')::unit AS factor,
('0.001 '||p||'m')::unit AS "0.001 m",
(p||'m')::unit AS "meter",
('1000 '||p||'m')::unit AS "1000 m",
('0.001 '||p||'g')::unit AS "0.001 g",
(p||'g')::unit AS "gram",
('1000 '||p||'g')::unit AS "1000 g"
FROM
prefixes;
p | factor | 0.001 m | meter | 1000 m | 0.001 g | gram | 1000 g
----+---------------+---------+--------+---------+----------+--------+----------
q | 1e-30 | 1e-33 m | 1 qm | 1 rm | 1e-36 kg | 1 qg | 1 rg
r | 1e-27 | 1 qm | 1 rm | 1 ym | 1 qg | 1 rg | 1 yg
y | 1e-24 | 1 rm | 1 ym | 1 zm | 1 rg | 1 yg | 1 zg
z | 1e-21 | 1 ym | 1 zm | 1 am | 1 yg | 1 zg | 1 ag
a | 1e-18 | 1 zm | 1 am | 1 fm | 1 zg | 1 ag | 1 fg
f | 1e-15 | 1 am | 1 fm | 1 pm | 1 ag | 1 fg | 1 pg
p | 1e-12 | 1 fm | 1 pm | 1 nm | 1 fg | 1 pg | 1 ng
n | 1e-09 | 1 pm | 1 nm | 1 µm | 1 pg | 1 ng | 1 µg
µ | 1e-06 | 1 nm | 1 µm | 1 mm | 1 ng | 1 µg | 1 mg
mu | 1e-06 | 1 nm | 1 µm | 1 mm | 1 ng | 1 µg | 1 mg
m | 0.001 | 1 µm | 1 mm | 1 m | 1 µg | 1 mg | 1 g
c | 0.01 | 10 µm | 10 mm | 10 m | 10 µg | 10 mg | 10 g
d | 0.1 | 100 µm | 100 mm | 100 m | 100 µg | 100 mg | 100 g
| 1 | 1 mm | 1 m | 1 km | 1 mg | 1 g | 1 kg
da | 10 | 10 mm | 10 m | 10 km | 10 mg | 10 g | 10 kg
h | 100 | 100 mm | 100 m | 100 km | 100 mg | 100 g | 100 kg
k | 1000 | 1 m | 1 km | 1 Mm | 1 g | 1 kg | 1 Mg
M | 1000000 | 1 km | 1 Mm | 1 Gm | 1 kg | 1 Mg | 1 Gg
G | 1000000000 | 1 Mm | 1 Gm | 1 Tm | 1 Mg | 1 Gg | 1 Tg
T | 1000000000000 | 1 Gm | 1 Tm | 1 Pm | 1 Gg | 1 Tg | 1 Pg
P | 1e+15 | 1 Tm | 1 Pm | 1 Em | 1 Tg | 1 Pg | 1 Eg
E | 1e+18 | 1 Pm | 1 Em | 1 Zm | 1 Pg | 1 Eg | 1 Zg
Z | 1e+21 | 1 Em | 1 Zm | 1 Ym | 1 Eg | 1 Zg | 1 Yg
Y | 1e+24 | 1 Zm | 1 Ym | 1 Rm | 1 Zg | 1 Yg | 1 Rg
R | 1e+27 | 1 Ym | 1 Rm | 1 Qm | 1 Yg | 1 Rg | 1 Qg
Q | 1e+30 | 1 Rm | 1 Qm | 1e+33 m | 1 Rg | 1 Qg | 1e+30 kg
(26 rows)
|
