> *********************************************************************
> *********** Note: "messages" has 35129 rows.  '.%' doesn't work *****
> *********************************************************************

logdb=# \d messages
           Table "messages"
 Attribute  |     Type     | Modifier 
------------+--------------+----------
 time_stamp | varchar(32)  | not null
 category   | varchar(32)  | 
 client     | varchar(128) | 
 message    | text         | 
Indices: category_id,
         client_id,
         time_stamp_id

logdb=# select count(*) from messages where client like 'kp.dhs.v%';
 count 
-------
  2955
(1 row)

logdb=# select count(*) from messages where client like 'kp.dhs.%';
 count 
-------
     0
(1 row)

logdb=# select count(*) from messages where client like 'kp.dhs%';
 count 
-------
  2955
(1 row)



> *********************************************************************
> *********** Note: "messages.2000_195-2000_220" has 28496 rows 
> ***********       and was created via a "SELECT * INTO TABLE ...."
> ***********       from "messages".  Note that '.%' works here!
> *********************************************************************

logdb=# \d messages.2000_195-2000_220
  Table "messages.2000_195-2000_220"
 Attribute  |     Type     | Modifier 
------------+--------------+----------
 time_stamp | varchar(32)  | 
 category   | varchar(32)  | 
 client     | varchar(128) | 
 message    | text         | 

logdb=# select count(*) from "messages.2000_195-2000_220" where client like 'kp. dhs%';
 count 
-------
 17657
(1 row)

logdb=# select count(*) from "messages.2000_195-2000_220" where client like 'kp. dhs.%';
 count 
-------
 17657
(1 row)

logdb=# select count(*) from "messages.2000_195-2000_220" where client like 'kp. dhs.v%';
 count 
-------
 17657
(1 row)

logdb=# \q