Обсуждение: "like" and "ilike" not working properly on postgresql 9.0.3 where clause, bug fix not mentioned on 9.0.5 either

To whom it may concern,

like and ilke not working on postgresql 9.0.3. Bug fix is not mentioned on
9.0.5 either. The same statement works very well on postgresql 8.4.

Kind Regards,
Mlungisi Sincuba

Hello

2011/11/18 Mlungisi Sincuba <msincuba@gmail.com>:
> To whom it may concern,
> like and ilke not working on postgresql 9.0.3. Bug fix is not mentioned on
> 9.0.5 either. The same statement works very well on postgresql 8.4.
> Kind Regards,
> Mlungisi Sincuba

can you send more informations, please? Can you send a related SQL
statement, result from 9.0 and 8.4?

Regards

Pavel Stehule

Mlungisi Sincuba <msincuba@gmail.com> wrote:
> To whom it may concern,
>
> like and ilke not working on postgresql 9.0.3. Bug fix is not
> mentioned on 9.0.5 either. The same statement works very well on
> postgresql 8.4.

They work for me.

Perhaps you used a different locale configuration under the new
version?

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

-Kevin