| 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: | Whole Thread | Raw Message | 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 |