Re: is this a bug or I am blind?

Gregory S. Williamson wrote:
>
> 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 missing it; 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 ?

But "like" without any wildcards should be the same as "=", but it isn't
in the original post.

--
Richard Huxton
Archonet Ltd