PolarDB:GiST indexes

Usage notes

-- Create a table that contains GeomGrid fields.
CREATE TABLE geomgrid_gist_test (
    id serial,
    code geomgrid
);

-- Insert a GeomGrid record.
INSERT INTO geomgrid_gist_test(code) VALUES('0102000F58182C0E'::GeomGrid);
INSERT INTO geomgrid_gist_test(code) VALUES('0102000F58182C0D'::GeomGrid);
INSERT INTO geomgrid_gist_test(code) VALUES('0102000F59163522'::GeomGrid);
INSERT INTO geomgrid_gist_test(code) VALUES('0102000F59163622'::GeomGrid);
INSERT INTO geomgrid_gist_test(code) VALUES('0102000F59163B22'::GeomGrid);

-- Create a GIST 2D spatial index in the code field.
CREATE INDEX geomgrid_gist_test_idx on geomgrid_gist_test using gist (code); 

-- Create a table that contains H3Grid fields.
CREATE TABLE h3grid_gist_test (
    id serial,
    code h3grid
);

-- Insert an H3Grid record.
INSERT INTO h3grid_gist_test(code) VALUES('010100FFFF846CD932AB08'::H3Grid);
INSERT INTO h3grid_gist_test(code) VALUES('010100FF7F366127CEA308'::H3Grid);
INSERT INTO h3grid_gist_test(code) VALUES('010100FF7F466C3B8EAA08'::H3Grid);
INSERT INTO h3grid_gist_test(code) VALUES('010100FFFF0C134D87A308'::H3Grid);
INSERT INTO h3grid_gist_test(code) VALUES('010100FF7FD95460EFA108'::H3Grid);

-- Create a GIST 2D spatial index in the code field.
CREATE INDEX h3grid_gist_test_idx on h3grid_gist_test using gist (code);