Do you have any odd locale settings or anything and what's
the table definition for the table in question?
It seems to do what I expect under my 7.0.2 system:
create table kp (name text);
insert into kp values ('kp.dhs.a');
insert into kp values ('kp.dhs.');
insert into kp values ('kp.dhs,d');
s
I have LIKE expressions:
(a) name LIKE 'kp.dhs.%'
(b) name LIKE 'kp.dhs%'
where the name column contains strings prefixed with "kp.dhs.".
I'm using postgresql 7.0.2.
Expression (a) fails to match any names while (b) matches
all strings prefixed with "kp.dhs", includin
