From 8ae9ad1cb8cfcaa929322ee3df48094f5ffd96e9 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 15 Sep 2000 18:45:31 +0000 Subject: Reimplement LIKE/ESCAPE as operators so that indexscan optimization can still work, per recent discussion on pghackers. Correct some bugs in ILIKE implementation. --- src/test/regress/expected/strings.out | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/test') 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"; -- cgit v1.2.1