Re: is this a bug or I am blind?

am 15.12.2005, um 14:12:23 +0100 mailte Mage folgendes:
> online=# select * from common_logins where username = 'potyty';
> uid | username | password | lastlogin | status | usertype | loginnum
> -----+----------+----------+-----------+--------+----------+----------
> (0 rows)
>
> online=# select * from common_logins where username like 'potyty';
> uid | username | password | lastlogin | status |
> usertype | loginnum
> --------+----------+----------+----------------------------+--------+----------+----------
> 155505 | potyty | board | 2004-08-16 17:45:55.723829 | A | S
> | 1
> 60067 | potyty | board | 2004-07-07 20:22:17.68699 | A | S
> | 3
> 174041 | potyty | board | 2005-02-17 00:00:13.706144 | A | S
> | 3
> (3 rows)

Try:

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 '.

HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===