From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: is this a bug or I am blind? |
Date: | 2005-12-15 13:23:03 |
Message-ID: | 20051215132259.GI3334@webserv.wug-glas.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 ===
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2005-12-15 13:28:20 | Re: is this a bug or I am blind? |
Previous Message | Richard Huxton | 2005-12-15 13:20:40 | Re: enable SSL on server |