Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE IF NOT EXISTS my_table (
    "US tank" TEXT,
    "DS tank" TEXT,
    "US batch n°" INT,
    "DS batch n°" INT
);
INSERT INTO my_table VALUES
    ('C41','K5',1418,1172),
    ('T65','STEP',4000,1012022),
    ('Citerne','D41',1012022,3641),
    ('T65','T43',4000,4000),
    ('X36','BB',7000,188821),
    ('T65','T43',4000,4000),
    ('X36','BB',7000,188822),
    ('T65','T43',4000,4000),
    ('X36','BB',7000,188823),
    ('T65','T43',4000,4000),
    ('X36','BB',7000,188824),
    ('T65','T43',4000,4000),
    ('X36','BB',7000,188825),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('X36','BB',7000,188826),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('X36','BB',7000,188827),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('X36','BB',7000,188828),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('L42','T41',1000,5502),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('X55','X36',1926,7001),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('X36','BB',7002,188829),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('X36','BB',7002,188830),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('X36','BB',7002,188831),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('X36','BB',7002,188832),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,4000),
    ('X36','BB',7002,188833),
    ('T65','T43',4000,4000),
    ('T65','T43',4000,0),
    ('T65','T43',4000,4000),
    ('X36','BB',7002,188834),
    ('T65','T43',4000,4000),
    ('X36','BB',7002,188835),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('X36','BB',7002,188836),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('X36','BB',7002,188837),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('X36','BB',7002,188838),
    ('T65','X56',4000,4000),
    ('Citerne','D41',1012022,3641),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('X36','BB',7002,188839),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('X36','BB',7002,188840),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('X36','BB',7002,188841),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('X36','BB',7002,188842),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('X36','BB',7002,188843),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('X36','BB',7002,188844),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('X36','BB',7002,188845),
    ('T65','X56',4000,4000),
    ('X55','X36',1926,7003),
    ('T65','X56',4000,4000),
    ('C41','K5',1418,1),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('X36','BB',7003,188846),
    ('L41','T40',500,6237),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('K5','L43',1,1001),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T41','T65',5502,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T41','STEP',5502,1012022),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('Citerne','C41',1012022,1418),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('K5','L42',2,1001),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('K5','L41',2,500),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T43','T65',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('K5','L42',2,1001),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000);
INSERT INTO my_table VALUES
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('C41','K5',1418,2),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('C40','K5',1551,2),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('K5','L44',2,1001),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('L40','T40',1012022,6237),
    ('T65','X56',4000,4000),
    ('L41','T40',500,6237),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T40','T65',6237,4000),
    ('T65','X56',4000,4000),
    ('T40','STEP',6237,1012022),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('D41','C41',3641,1419),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('L41','T41',500,5503),
    ('L44','T41',1001,5503),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T41','T65',5503,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T41','STEP',5503,1012022),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('L44','T40',1001,6238),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('T65','X56',4000,4000),
    ('K5','L45',3,1000),
    ('T40','T65',6238,4000),
    ('C40','K5',1551,3),
    ('T65','X56',4000,402),
    ('V65','X53',3002,2011);

SELECT * FROM my_table

CREATE TABLE



INSERT 0 250



INSERT 0 193




US tank
DS tank
US batch n°
DS batch n°


C41
K5
1418
1172

T65
STEP
4000
1012022

Citerne
D41
1012022
3641

T65
T43
4000
4000

X36
BB
7000
188821

T65
T43
4000
4000

X36
BB
7000
188822

T65
T43
4000
4000

X36
BB
7000
188823

T65
T43
4000
4000

X36
BB
7000
188824

T65
T43
4000
4000

X36
BB
7000
188825

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

X36
BB
7000
188826

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

X36
BB
7000
188827

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

X36
BB
7000
188828

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

L42
T41
1000
5502

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

X55
X36
1926
7001

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

X36
BB
7002
188829

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

X36
BB
7002
188830

T65
T43
4000
4000

T65
T43
4000
4000

X36
BB
7002
188831

T65
T43
4000
4000

T65
T43
4000
4000

T65
T43
4000
4000

X36
BB
7002
188832

T65
T43
4000
4000

T65
T43
4000
4000

X36
BB
7002
188833

T65
T43
4000
4000

T65
T43
4000
0

T65
T43
4000
4000

X36
BB
7002
188834

T65
T43
4000
4000

X36
BB
7002
188835

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

X36
BB
7002
188836

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

X36
BB
7002
188837

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

X36
BB
7002
188838

T65
X56
4000
4000

Citerne
D41
1012022
3641

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

X36
BB
7002
188839

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

X36
BB
7002
188840

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

X36
BB
7002
188841

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

X36
BB
7002
188842

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

X36
BB
7002
188843

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

X36
BB
7002
188844

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

X36
BB
7002
188845

T65
X56
4000
4000

X55
X36
1926
7003

T65
X56
4000
4000

C41
K5
1418
1

T65
X56
4000
4000

T65
X56
4000
4000

X36
BB
7003
188846

L41
T40
500
6237

T65
X56
4000
4000

T65
X56
4000
4000

K5
L43
1
1001

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T41
T65
5502
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T41
STEP
5502
1012022

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

Citerne
C41
1012022
1418

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

K5
L42
2
1001

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

K5
L41
2
500

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T43
T65
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

K5
L42
2
1001

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

C41
K5
1418
2

T65
X56
4000
4000

T65
X56
4000
4000

C40
K5
1551
2

T65
X56
4000
4000

T65
X56
4000
4000

K5
L44
2
1001

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

L40
T40
1012022
6237

T65
X56
4000
4000

L41
T40
500
6237

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T40
T65
6237
4000

T65
X56
4000
4000

T40
STEP
6237
1012022

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

D41
C41
3641
1419

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

L41
T41
500
5503

L44
T41
1001
5503

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T41
T65
5503
4000

T65
X56
4000
4000

T65
X56
4000
4000

T41
STEP
5503
1012022

T65
X56
4000
4000

T65
X56
4000
4000

L44
T40
1001
6238

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

T65
X56
4000
4000

K5
L45
3
1000

T40
T65
6238
4000

C40
K5
1551
3

T65
X56
4000
402

V65
X53
3002
2011



SELECT 443


CREATE TABLE IF NOT EXISTS Expected_result (
    Citerne INT,
    D41 INT,
    C41 INT,
    K5 INT,
    L41 INT,
    L42 INT,
    L43 INT,
    L44 INT,
    L45 INT,
    T40 INT,
    T41 INT,
    T65 INT,
    STEP INT,
    T43 INT,
    X56 INT
);
INSERT INTO Expected_result VALUES
    (1012022,3641,1419,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
    (1012022,3641,1419,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
    (1012022,NULL,1418,1,NULL,NULL,1001,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
    (1012022,NULL,1418,2,NULL,1001,NULL,NULL,NULL,5502,NULL,NULL,NULL,NULL,NULL),
    (1012022,NULL,1418,2,500,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
    (1012022,NULL,1418,2,NULL,1001,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
    (1012022,NULL,1418,2,NULL,NULL,NULL,1001,NULL,6238,NULL,4000,NULL,4000,NULL),
    (1012022,NULL,1418,2,NULL,NULL,NULL,1001,NULL,6238,NULL,4000,NULL,NULL,4000),
    (1012022,NULL,1418,2,NULL,NULL,NULL,1001,NULL,NULL,5503,4000,NULL,4000,NULL),
    (1012022,NULL,1418,2,NULL,NULL,NULL,1001,NULL,NULL,5503,4000,NULL,NULL,4000),
    (1012022,NULL,1418,2,NULL,NULL,NULL,1001,NULL,NULL,5503,4000,1012022,NULL,NULL),
    (1012022,NULL,1418,1172,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

SELECT * FROM Expected_result

CREATE TABLE



INSERT 0 12




citerne
d41
c41
k5
l41
l42
l43
l44
l45
t40
t41
t65
step
t43
x56


1012022
3641
1419
null
null
null
null
null
null
null
null
null
null
null
null

1012022
3641
1419
null
null
null
null
null
null
null
null
null
null
null
null

1012022
null
1418
1
null
null
1001
null
null
null
null
null
null
null
null

1012022
null
1418
2
null
1001
null
null
null
5502
null
null
null
null
null

1012022
null
1418
2
500
null
null
null
null
null
null
null
null
null
null

1012022
null
1418
2
null
1001
null
null
null
null
null
null
null
null
null

1012022
null
1418
2
null
null
null
1001
null
6238
null
4000
null
4000
null

1012022
null
1418
2
null
null
null
1001
null
6238
null
4000
null
null
4000

1012022
null
1418
2
null
null
null
1001
null
null
5503
4000
null
4000
null

1012022
null
1418
2
null
null
null
1001
null
null
5503
4000
null
null
4000

1012022
null
1418
2
null
null
null
1001
null
null
5503
4000
1012022
null
null

1012022
null
1418
1172
null
null
null
null
null
null
null
null
null
null
null



SELECT 12


CREATE OR REPLACE PROCEDURE create_composite_type() LANGUAGE plpgsql AS $$
DECLARE
  column_list text ;
BEGIN
  SELECT string_agg(DISTINCT quote_ident(t.tank) || ' text', ',')
    INTO column_list
    FROM ( SELECT "US tank" FROM my_table
           UNION ALL 
           SELECT "DS tank" FROM my_table
         ) AS t(tank) ;
  
  EXECUTE 'DROP TYPE IF EXISTS composite_type' ;
  EXECUTE 'CREATE TYPE composite_type AS (' || column_list || ')' ;
END ;
$$ ;

CREATE PROCEDURE


CALL create_composite_type() ;

SELECT (jsonb_populate_record( null :: composite_type
                             , jsonb_object_agg(t.tank, t.batch)
                             )
       ).*
 FROM ( SELECT "US tank" AS tank, "US batch n°" AS batch FROM my_table
        UNION 
        SELECT "DS tank", "DS batch n°" FROM my_table
      ) AS t ;

CALL




BB
C40
C41
Citerne
D41
K5
L40
L41
L42
L43
L44
L45
STEP
T40
T41
T43
T65
V65
X36
X53
X55
X56


188829
1551
1419
1012022
3641
1
1012022
500
1000
1001
1001
1000
1012022
6237
5502
4000
4000
3002
7000
2011
1926
402



SELECT 1
citerne	d41	c41	k5	l41	l42	l43	l44	l45	t40	t41	t65	step	t43	x56
1012022	3641	1419	null	null	null	null	null	null	null	null	null	null	null	null
1012022	3641	1419	null	null	null	null	null	null	null	null	null	null	null	null
1012022	null	1418	1	null	null	1001	null	null	null	null	null	null	null	null
1012022	null	1418	2	null	1001	null	null	null	5502	null	null	null	null	null
1012022	null	1418	2	500	null	null	null	null	null	null	null	null	null	null
1012022	null	1418	2	null	1001	null	null	null	null	null	null	null	null	null
1012022	null	1418	2	null	null	null	1001	null	6238	null	4000	null	4000	null
1012022	null	1418	2	null	null	null	1001	null	6238	null	4000	null	null	4000
1012022	null	1418	2	null	null	null	1001	null	null	5503	4000	null	4000	null
1012022	null	1418	2	null	null	null	1001	null	null	5503	4000	null	null	4000
1012022	null	1418	2	null	null	null	1001	null	null	5503	4000	1012022	null	null
1012022	null	1418	1172	null	null	null	null	null	null	null	null	null	null	null