Re: is this a bug or I am blind? - Mailing list pgsql-general

From Gregory S. Williamson
Subject Re: is this a bug or I am blind?
Date
Msg-id 71E37EF6B7DCC1499CEA0316A2568328024BBCE0@loki.wc.globexplorer.net
Whole thread Raw
In response to is this a bug or I am blind?  (Mage <mage@mage.hu>)
Responses Re: is this a bug or I am blind?
List pgsql-general
>
> 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

I am puzzled by the lack of a "%" in the LIKE query. When I try this on postgres 7.4 and 8.0 I get no rows when I am
missingit; including it works as expected. 

The names have been changed to protect the guilty ;-} but the core of it is true -- no "%" means wierdnesses, I think.

gex_runtime=# select gex_clientname from gex_clients where gex_clientname like 'Home';
 gex_clientname
----------------
(0 rows)

gex_runtime=# select gex_clientname from gex_clients where gex_clientname like 'Home%';
                        gex_clientname
--------------------------------------------------------------
 HomeHappinesses
 HomeMorgageValues, Inc.
(2 rows)

Could you try your query again with the wild card ?

HTH

Greg Williamson
DBA
GlobeXplorer LLC



pgsql-general by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: Installing the latest 8.1.1 rpms question.
Next
From: Jaime Casanova
Date:
Subject: Re: is this a bug or I am blind?