Skip site navigation (1) Skip section navigation (2)

Re: Bug in ILIKE?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Bug in ILIKE?
Date: 2008-09-26 03:45:55
Message-ID: 7866.1222400755@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> Tom Lane wrote:
>> So I'm for the definition that escape-anything means exactly anything,
>> without any special treatment that it would otherwise have.  And in
>> the case of ILIKE it seems like "no special treatment" should mean
>> "case insensitive match".

> Well, it looks to me to be pretty easily fixable. Given the above it 
> seems to me marginal to call it a bug, though. I don't have very strong 
> feelings, but I am generally opposed to changing the visible behaviour 
> in stable releases unless something is clearly a bug.

Well, there are two possible interpretations: (1) it's a bug, or (2)
it's an intentional, about-to-be-documented feature that backslashing a
letter makes it case-sensitive in ILIKE.

I do not care for interpretation #2 ... especially in view of your
observation (confirmed here) that pre-8.3 releases didn't do this.
I think it's just a bug in 8.3.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: David E. WheelerDate: 2008-09-26 04:24:12
Subject: Re: Bug in ILIKE?
Previous:From: Andrew DunstanDate: 2008-09-26 03:35:56
Subject: Re: Bug in ILIKE?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group