Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TEMP TABLE tmp_table(input_value int, value_100 float);

DO
LANGUAGE plpgsql
$do$
DECLARE
   i int;
BEGIN
   FOR i IN
      SELECT generate_series(2, 100, 2)
   LOOP
      INSERT INTO tmp_table(input_value, value_100)
      VALUES (i, i::float / 100);
      -- COMMIT;  -- ?
   END LOOP;
END
$do$;

CREATE TABLE



DO


TABLE tmp_table;


input_value
value_100


2
0.02

4
0.04

6
0.06

8
0.08

10
0.1

12
0.12

14
0.14

16
0.16

18
0.18

20
0.2

22
0.22

24
0.24

26
0.26

28
0.28

30
0.3

32
0.32

34
0.34

36
0.36

38
0.38

40
0.4

42
0.42

44
0.44

46
0.46

48
0.48

50
0.5

52
0.52

54
0.54

56
0.56

58
0.58

60
0.6

62
0.62

64
0.64

66
0.66

68
0.68

70
0.7

72
0.72

74
0.74

76
0.76

78
0.78

80
0.8

82
0.82

84
0.84

86
0.86

88
0.88

90
0.9

92
0.92

94
0.94

96
0.96

98
0.98

100
1



SELECT 50


-- the same, much simpler:
CREATE TEMP TABLE tmp_table2 AS
SELECT g AS input_value, g::float / 100 AS value_100
FROM   generate_series(2, 100, 2) g;

SELECT 50


TABLE tmp_table2;


input_value
value_100


2
0.02

4
0.04

6
0.06

8
0.08

10
0.1

12
0.12

14
0.14

16
0.16

18
0.18

20
0.2

22
0.22

24
0.24

26
0.26

28
0.28

30
0.3

32
0.32

34
0.34

36
0.36

38
0.38

40
0.4

42
0.42

44
0.44

46
0.46

48
0.48

50
0.5

52
0.52

54
0.54

56
0.56

58
0.58

60
0.6

62
0.62

64
0.64

66
0.66

68
0.68

70
0.7

72
0.72

74
0.74

76
0.76

78
0.78

80
0.8

82
0.82

84
0.84

86
0.86

88
0.88

90
0.9

92
0.92

94
0.94

96
0.96

98
0.98

100
1



SELECT 50

input_value	value_100
2	0.02
4	0.04
6	0.06
8	0.08
10	0.1
12	0.12
14	0.14
16	0.16
18	0.18
20	0.2
22	0.22
24	0.24
26	0.26
28	0.28
30	0.3
32	0.32
34	0.34
36	0.36
38	0.38
40	0.4
42	0.42
44	0.44
46	0.46
48	0.48
50	0.5
52	0.52
54	0.54
56	0.56
58	0.58
60	0.6
62	0.62
64	0.64
66	0.66
68	0.68
70	0.7
72	0.72
74	0.74
76	0.76
78	0.78
80	0.8
82	0.82
84	0.84
86	0.86
88	0.88
90	0.9
92	0.92
94	0.94
96	0.96
98	0.98
100	1