Re: LIKE erratic? or unseen DB corruption?
От | Peter Eisentraut |
---|---|
Тема | Re: LIKE erratic? or unseen DB corruption? |
Дата | |
Msg-id | Pine.LNX.4.30.0105211917430.757-100000@peter.localdomain обсуждение исходный текст |
Ответ на | LIKE erratic? or unseen DB corruption? (Frank Miles <fpm@u.washington.edu>) |
Список | pgsql-general |
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@gmx.net http://funkturm.homeip.net/~peter
В списке pgsql-general по дате отправления: