Bug in ILIKE function?

Started by Christopher Kings-Lynneabout 25 years ago5 messages
#1Christopher Kings-Lynne
chriskl@familyhealth.com.au

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

#2Hannu Krosing
hannu@tm.ee
In reply to: Christopher Kings-Lynne (#1)
Re: 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

#3Peter Eisentraut
peter_e@gmx.net
In reply to: Christopher Kings-Lynne (#1)
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/

#4Christopher Kings-Lynne
chriskl@familyhealth.com.au
In reply to: Peter Eisentraut (#3)
RE: Bug in ILIKE function?

That's odd, because it's in the 7.0.3 documentation...

Chris

Show quoted text

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

#5Tom Lane
tgl@sss.pgh.pa.us
In reply to: Christopher Kings-Lynne (#4)
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