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