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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
