From: | Jaime Casanova <systemguards(at)gmail(dot)com> |
---|---|
To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: is this a bug or I am blind? |
Date: | 2005-12-15 13:28:20 |
Message-ID: | c2d9e70e0512150528j3c84c462rfa886504c0bcf43e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 ;)
From | Date | Subject | |
---|---|---|---|
Next Message | David Rysdam | 2005-12-15 13:31:43 | Re: "incomplete startup packet" on SGI |
Previous Message | A. Kretschmer | 2005-12-15 13:23:03 | Re: is this a bug or I am blind? |