James Cloos <cloos(at)jhcloos(dot)com> writes:
> Is there any contraindication to recasting:
> foo ILIKE 'bar'
> LOWER(foo) LIKE LOWER('bar')
In some locales those are not equivalent, I believe, or at least
shouldn't be. (What the current code actually does is a separate
> Perhaps the parser could read the former as the latter?
Not unless the equivalence can be shown to be exact, which I doubt.
In any case it's not obvious why LOWER rather than UPPER.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Vlad Arkhipov||Date: 2012-12-29 01:36:55|
|Subject: Rewriter hook|
|Previous:||From: Tom Lane||Date: 2012-12-28 23:35:02|
|Subject: Re: enhanced error fields|