Re: is this a bug or I am blind?

On 12/15/05, A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com> wrote:
> 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 '.
>
>

even is that is true i think you need the "comodin characters" (ie: %.
_) to make "like" behave different from simple comparisons

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

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)