Re: is this a bug or I am blind?

A. Kretschmer wrote:

>
>select *, length(username), length('potyty') from common_logins where username like 'potyty';
>
>
>My guess:
>
>select length(username) from common_logins where username like 'potyty';
>
>is _NOT_ 6, there is a SPACE like 'potyty '.
>
>
>
If you look my 3rd query, you will see that there are no spaces, however:

select *, length(username), length('potyty') from common_logins where
username like 'potyty';
  uid   | username | password |         lastlogin          | status |
usertype | loginnum | length | length
--------+----------+----------+----------------------------+--------+----------+----------+--------+--------
 155505 | potyty   | board    | 2004-08-16 17:45:55.723829 | A      |
S        |        1 |      6 |      6
  60067 | potyty   | board    | 2004-07-07 20:22:17.68699  | A      |
S        |        3 |      6 |      6
 174041 | potyty   | board    | 2005-02-17 00:00:13.706144 | A      |
S        |        3 |      6 |      6
(3 rows)

       Mage