summaryrefslogtreecommitdiff
path: root/src/test
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2000-09-15 18:45:31 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2000-09-15 18:45:31 +0000
commit8ae9ad1cb8cfcaa929322ee3df48094f5ffd96e9 (patch)
treee72ebab2801d58150f1ce72f488e005ab23854ba /src/test
parent148f905f4185bbad191bceba5e7a173b38e7d3ba (diff)
downloadpostgresql-8ae9ad1cb8cfcaa929322ee3df48094f5ffd96e9.tar.gz
Reimplement LIKE/ESCAPE as operators so that indexscan optimization
can still work, per recent discussion on pghackers. Correct some bugs in ILIKE implementation.
Diffstat (limited to 'src/test')
-rw-r--r--src/test/regress/expected/strings.out4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/strings.out b/src/test/regress/expected/strings.out
index 398303694b..e59ba8e1df 100644
--- a/src/test/regress/expected/strings.out
+++ b/src/test/regress/expected/strings.out
@@ -443,13 +443,13 @@ SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";
SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
true
------
- f
+ t
(1 row)
SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";
false
-------
- t
+ f
(1 row)
SELECT 'Hawkeye' ILIKE 'h%' AS "true";