Re: equal and like

In response to "Schwéger Gábor" <gabor@schweger.hu>:
>
> This is my first post to this list.
> Our database moved to a larger partition.
> And now I have a problem with a select query:
> db=# SELECT id, login FROM u WHERE login LIKE 'bellamarth';
>    id   |    login
> --------+-------------
>  173002 | bellamarth
> (1 row)
>
> db=# SELECT id, login FROM u WHERE login = 'bellamarth';
>  id | login
> ----+-------
> (0 rows)
>
> The type of login is text.
> What is the problem with the equal sign?
> psql server version: 8.2.11
>
> Could you help me?

Just a guess, but does the problem go away if you do
REINDEX table u;

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023