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


Wed, 13 Dec 2000 15:27:44 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Bug in ILIKE function?
Christopher Kings-Lynne wrote:
> 
> 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.)

AFAIK postgres 7.0.3 does not have it, ILIKE appeared in 7.1 

But you could use the case-independant regular expressions.

------------
Hannu

Wed, 13 Dec 2000 10:58:25 +0000
Hannu Krosing <hannu@tm.ee>
Re: Bug in ILIKE function?
Christopher Kings-Lynne writes:

> I have just tried using the ILIKE function in 7.0.3.

There is no ILIKE function in 7.0.3.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Wed, 13 Dec 2000 20:28:52 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: Bug in ILIKE function?
That's odd, because it's in the 7.0.3 documentation...

Chris

> -----Original Message-----
> From: Peter Eisentraut [mailto:peter_e@gmx.net]
> Sent: Thursday, December 14, 2000 3:29 AM
> To: Christopher Kings-Lynne
> Cc: Pgsql-Hackers
> Subject: Re: [HACKERS] Bug in ILIKE function?
> 
> 
> Christopher Kings-Lynne writes:
> 
> > I have just tried using the ILIKE function in 7.0.3.
> 
> There is no ILIKE function in 7.0.3.
> 
> -- 
> Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/
> 

Thu, 14 Dec 2000 09:06:57 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
RE: Bug in ILIKE function?
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> That's odd, because it's in the 7.0.3 documentation...

Where?  A quick grep doesn't find it there anywhere.

			regards, tom lane

Wed, 13 Dec 2000 21:35:30 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Bug in ILIKE function? 