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
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 |