table-cyclist-stats
INSERT INTO cycling.cyclist_stats
(id, lastname, basics)
VALUES (
6cbc55e9-1943-47dc-91f2-f8f9e95992eb,
'VIGANO',
{ birthday:'1984-06-12', nationality:'Italy', weight:'67 kg', height:'1.82 m' }
);
INSERT INTO cycling.cyclist_stats
(id, lastname, basics)
VALUES (
e7ae5cf3-d358-4d99-b900-85902fda9bb0,
'FRAME',
{ birthday:'1993-06-18', nationality:'New Zealand', weight:null, height:null }
);
INSERT INTO cycling.cyclist_stats
(id, lastname, basics)
VALUES (
220844bf-4860-49d6-9a4b-6b5d3a79cbfb,
'TIRALONGO',
{ birthday:'1977-07-08', nationality:'Italy', weight:'63 kg', height:'1.78 m' }
);
SELECT * FROM cycling.cyclist_stats
WHERE id = 220844bf-4860-49d6-9a4b-6b5d3a79cbfb;;
DESCRIBE TABLE cycling.cyclist_stats;
ALTER TABLE cycling.cyclist_stats
DROP basics;
CREATE TABLE IF NOT EXISTS cycling.cyclist_stats (
id UUID PRIMARY KEY,
lastname text,
basics basic_info
);
DESCRIBE TABLE cycling.cyclist_stats;
DROP TABLE IF EXISTS cycling.cyclist_stats;
# CREATE TYPE IF NOT EXISTS cycling.basic_info (
# birthday timestamp,
# nationality text,
# height text,
# weight text
# );
UPDATE cycling.cyclist_stats SET basics.birthday = '2000-12-12'
WHERE id = 220844bf-4860-49d6-9a4b-6b5d3a79cbfb;