table-race-starts

INSERT INTO cycling.race_starts (cyclist_name, rnumbers) VALUES ('John DEGENKOLB', [39, 7, 14]);

CREATE INDEX IF NOT EXISTS rnumbers_idx ON cycling.race_starts ( FULL(rnumbers) );

CREATE CUSTOM INDEX IF NOT EXISTS rnumbers_idx ON cycling.race_starts ( FULL(rnumbers) )
USING 'StorageAttachedIndex';

DESCRIBE INDEX cycling.rnumbers_idx;

DESCRIBE INDEX cycling.rnumbers_idx;

DROP INDEX IF EXISTS cycling.rnumbers_idx;

SELECT * FROM cycling.race_starts WHERE rnumbers = [39, 7, 14];

SELECT * FROM cycling.race_starts WHERE rnumbers = [39, 7, 14];

CREATE TABLE IF NOT EXISTS cycling.race_starts (
  cyclist_name text PRIMARY KEY,
  rnumbers FROZEN<LIST<int>>
);

DESCRIBE TABLE cycling.race_starts;

DROP TABLE IF EXISTS cycling.race_starts;

Give Feedback