equal and like

From: Schwéger Gábor <gabor(at)schweger(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: equal and like
Date: 2008-12-04 18:30:14
Message-ID: 2436.89.133.144.132.1228415414.squirrel@webmail.schweger.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi List,

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?

Gabor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harald Fuchs 2008-12-04 18:32:59 Re: cumulative count
Previous Message Carson Farmer 2008-12-04 17:53:06 cumulative count