Re: LIKE erratic? or unseen DB corruption?

Frank Miles writes:

> Running 7.1(.0) on a PC running Debian Linux (potato), I have a strange situation in psql:
>
> A direct query gets appropriate rows of data:
>
> dbname=# select * from partdef where shpname = 'IDC16W';
> pn_id | class | num | mt | ver | loc_id | unit_id | subptcnt | shpname | value | descrip
> -------+-------+------+----+-----+--------+---------+----------+------------------+------------+---------
> 17 | 328 | 08X2 | 0 | 0 | | | 1 | IDC16W | Header-8x2 |
> 11 | 323 | 08X2 | 0 | 0 | | | 1 | IDC16W | Header-8x2 |
>
> ...while the very same query (substituting LIKE for the '=' sign) gets nothing!?
>
> dbname=# select * from partdef where shpname LIKE 'IDC16W';
> pn_id | class | num | mt | ver | loc_id | unit_id | subptcnt | shpname | value | descrip
> -------+-------+-----+----+-----+--------+---------+----------+---------+-------+---------
> (0 rows)

This is supposed to work. What data type is column "shpname"? Did you
configure with locale, and if so, what locale are you running under? Is
there an index on "shpname"?

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter