From: | Schwéger Gábor <gabor(at)schweger(dot)hu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: equal and like |
Date: | 2008-12-10 08:17:54 |
Message-ID: | 1531.81.182.59.127.1228897074.squirrel@webmail.schweger.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(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
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Morgan Lloyd | 2008-12-10 08:54:50 | PostgreSQL and eval() |
Previous Message | Tonny Sapri | 2008-12-10 08:12:19 | quit milis |