Thank You. After reindex it's working fine. Gabor On Ked, December 9, 2008 23:06, Bill Moran wrote: > In response to "Schwéger Gábor" <gabor@xxxxxxxxxxx>: >> >> 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@xxxxxxxxxxxxxxxxxxxxxxx > Phone: 412-422-3463x4023 > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
