Postgres Pro
Downloads
Home   >   mailing lists

Thread: Bug in ILIKE function?

Bug in ILIKE function?

From
"Christopher Kings-Lynne"
Date:
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
LIKEexpression~~  | varchar     | text        | bool      | matches LIKE expression
 

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

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

Chris

Re: Bug in ILIKE function?

From
Hannu Krosing
Date:
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

Re: Bug in ILIKE function?

From
Peter Eisentraut
Date:
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/

RE: Bug in ILIKE function?

From
"Christopher Kings-Lynne"
Date:
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/
>

Re: Bug in ILIKE function?

From
Tom Lane
Date:
"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