diff options
Diffstat (limited to 'contrib/intarray/sql')
-rw-r--r-- | contrib/intarray/sql/_int.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/contrib/intarray/sql/_int.sql b/contrib/intarray/sql/_int.sql index 481754057e..1588e3b514 100644 --- a/contrib/intarray/sql/_int.sql +++ b/contrib/intarray/sql/_int.sql @@ -111,7 +111,7 @@ SELECT count(*) from test__int WHERE a @> '{20,23}' or a @> '{50,68}'; SELECT count(*) from test__int WHERE a @@ '(20&23)|(50&68)'; DROP INDEX text_idx; -CREATE INDEX text_idx on test__int using gin ( a ); +CREATE INDEX text_idx on test__int using gin ( a gin__int_ops ); SELECT count(*) from test__int WHERE a && '{23,50}'; SELECT count(*) from test__int WHERE a @@ '23|50'; |