Re: equal and like

In response to "Schwéger Gábor" <gabor(at)schweger(dot)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(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023