Select with string that has a lone hyphen yields nothing
От | Beevee |
---|---|
Тема | Select with string that has a lone hyphen yields nothing |
Дата | |
Msg-id | 8bfa2846-1804-42c3-a928-e054276a3ec8@r6g2000vbh.googlegroups.com обсуждение исходный текст |
Ответы |
Re: Select with string that has a lone hyphen yields nothing
|
Список | pgsql-general |
I have a product names table like this: datab=# select product_id, name from table.product_synonyms where name ilike '%%olympus e-pl1%%'; product_id | name ------------ +--------------------------------------------------------------------------------------------------------------------------------------- 8736 | Olympus E-PL1 8736 | Olympus E-PL1 Interchangeable Lens Type Live View Digital Camera – Black (Body Only) (Call for pre-order. Available on: 2010-04-09) 8736 | Olympus E-PL1 Interchangeable Lens Type Live View Digital Camera – Blue (Body Only) 8736 | Olympus E-PL1 Interchangeable Lens Type Live View Digital Camera w/ ED 14-42mm f3.5-5.6 (champagne/gold) (4 rows) Any select statement prior to the hyphen yields a result, but from the hyphen on yields nothing: datab=# select product_id, name from table.product_synonyms where name ilike '%%Olympus E-PL1 Interchangeable Lens Type Live View Digital Camera - Blue %%'; product_id | name ------------+------ (0 rows) Any ideas how to fix this?
В списке pgsql-general по дате отправления: