Sample Header Ad - 728x90

Gin indexing in postgres

0 votes
2 answers
2429 views
I have four columns project_id, custom_event(boolean), page_view(boolean), event_url(text). I usually do like a regex operation in event_url column and my query will be all the four columns in that order I specified. When I try to create like this CREATE INDEX event_url_index ON event_data USING gin (project_id, custom_event, page_view, event_url gin_trgm_ops) it's giving me an error like this > data type boolean has no default operator class for access method "gin" Can anyone help me how to solve this issue?
Asked by NAREN PUSHPARAJU (21 rep)
Jun 6, 2019, 05:23 AM
Last activity: Oct 2, 2019, 08:02 AM