SwifQL icon indicating copy to clipboard operation
SwifQL copied to clipboard

Implement createIndex with column operator class

Open EthanLozano opened this issue 5 years ago • 0 comments

Extend IndexItem to support an operator class.

Postgres allows indexes to specify an operator class. For instance, the pg_trgm extension could have the following index declaration:

CREATE INDEX trgm_idx ON test_trgm USING GIN (t gin_trgm_ops);

It appears that IndexItem.column(colum:order:) could have an "opclass" parameter for operator class configuration.

For the time being, I used an updateBuilder and raw sql to create an index with an operator class.

EthanLozano avatar Nov 12 '20 01:11 EthanLozano