diff options
| -rw-r--r-- | contrib/citext/expected/citext.out | 1 | ||||
| -rw-r--r-- | contrib/citext/expected/citext_1.out | 1 | ||||
| -rw-r--r-- | contrib/citext/sql/citext.sql | 2 |
3 files changed, 4 insertions, 0 deletions
diff --git a/contrib/citext/expected/citext.out b/contrib/citext/expected/citext.out index 000c9256422..a6265d857dc 100644 --- a/contrib/citext/expected/citext.out +++ b/contrib/citext/expected/citext.out @@ -325,6 +325,7 @@ VALUES ('aardvark'), ('aba'), ('ABC'), ('abd'); +CREATE INDEX srt_name ON srt (name); -- Check the min() and max() aggregates, with and without index. set enable_seqscan = off; SELECT MIN(name) AS "AAA" FROM srt; diff --git a/contrib/citext/expected/citext_1.out b/contrib/citext/expected/citext_1.out index 8373dc88469..36342be7c1d 100644 --- a/contrib/citext/expected/citext_1.out +++ b/contrib/citext/expected/citext_1.out @@ -325,6 +325,7 @@ VALUES ('aardvark'), ('aba'), ('ABC'), ('abd'); +CREATE INDEX srt_name ON srt (name); -- Check the min() and max() aggregates, with and without index. set enable_seqscan = off; SELECT MIN(name) AS "AAA" FROM srt; diff --git a/contrib/citext/sql/citext.sql b/contrib/citext/sql/citext.sql index 07497401a4d..65ef05b9312 100644 --- a/contrib/citext/sql/citext.sql +++ b/contrib/citext/sql/citext.sql @@ -127,6 +127,8 @@ VALUES ('aardvark'), ('ABC'), ('abd'); +CREATE INDEX srt_name ON srt (name); + -- Check the min() and max() aggregates, with and without index. set enable_seqscan = off; SELECT MIN(name) AS "AAA" FROM srt; |