Bug in ILIKE function?

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Pgsql-Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Bug in ILIKE function?
Date: 2000-12-13 07:27:44
Message-ID: NEBBIOAJBMEENKACLNPCKEKKCCAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I have just tried using the ILIKE function in 7.0.3. I assume that it is
just a case-insensitive version of LIKE. (Please correct me if I am wrong
on this assumption.)

This is my example test case:

usa=# select 'test' LIKE '%es%';
?column?
----------
t
(1 row)

usa=# select 'test' ILIKE '%es%';
ERROR: parser: parse error at or near "ilike"
usa=#

HEre is a dump (\do) of the some of the tilde operators in 7.0.3:

~* | bpchar | text | bool | matches regex.,
case-insensitive
~* | name | text | bool | matches regex.,
case-insensitive
~* | text | text | bool | matches regex.,
case-insensitive
~* | varchar | text | bool | matches regex.,
case-insensitive
~= | box | box | bool | same as
~= | circle | circle | bool | same as
~= | point | point | bool | same as
~= | polygon | polygon | bool | same as
~= | tinterval | tinterval | bool | same as
~~ | bpchar | text | bool | matches LIKE expression
~~ | name | text | bool | matches LIKE expression
~~ | text | text | bool | matches LIKE expression
~~ | varchar | text | bool | matches LIKE expression

Notice that there's no ILIKE operators, (~~*), at all!

Is this documented, but not implemented or what????

Chris

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Karel Zak 2000-12-13 08:03:24 Re: C function proposal redux
Previous Message mlw 2000-12-13 05:31:38 C function proposal redux