tsearch bug in 7.2.1?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема tsearch bug in 7.2.1?
Дата
Msg-id GNELIHDDFBOCMGBFGEFOCELHCDAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответы Re: tsearch bug in 7.2.1?
Список pgsql-hackers
Hi,

I noticed this behaviour:

usa=# SELECT rr.id, rr.name, rr.description FROM recipe_recipes rr WHERE
rr.ftiidx ## 's';id  |               name               |
description
-----+----------------------------------+-----------------------------------
------------------------------------------------202 | Bird's Nest                      | An egg nestled in a crispy,
hot
bread roll.293 | Reuben Triple S                  | Corn beef, swiss cheese and
sauerkraut on pumpernickel. 30 | Hedgehogs                        | This is comfort food at it's
yummiest.130 | Hearty Apple & Cinnamon Porridge | A great way to warm you up on a
winter's morning. 83 | Banana & Apple Compote           | Great way to finish a meal on a
cool winter's day.139 | Minestrone                       | Served with a crusty roll, this
soup is a meal on it's own. 75 | Mango Sorbet                     | A mango-lover's delight. 19 | Chunky Vegetable
Chowder        | Serve this soup with a crusty roll
 
and it's a hearty meal on a cold winter's eve. 36 | Lemon Fish Rolls                 | A pleasant way to include fish
in
your family's diet.
(9 rows)

usa=# SELECT rr.id, rr.name, rr.description FROM recipe_recipes rr WHERE
rr.ftiidx ## 's|a';
ERROR:  Your query contained only stopword(s), ignored
usa=# SELECT rr.id, rr.name, rr.description FROM recipe_recipes rr WHERE
rr.ftiidx ## 's|x';id  |               name               |
description
-----+----------------------------------+-----------------------------------
------------------------------------------------202 | Bird's Nest                      | An egg nestled in a crispy,
hot
bread roll.293 | Reuben Triple S                  | Corn beef, swiss cheese and
sauerkraut on pumpernickel. 30 | Hedgehogs                        | This is comfort food at it's
yummiest.130 | Hearty Apple & Cinnamon Porridge | A great way to warm you up on a
winter's morning. 83 | Banana & Apple Compote           | Great way to finish a meal on a
cool winter's day.139 | Minestrone                       | Served with a crusty roll, this
soup is a meal on it's own. 75 | Mango Sorbet                     | A mango-lover's delight. 19 | Chunky Vegetable
Chowder        | Serve this soup with a crusty roll
 
and it's a hearty meal on a cold winter's eve. 36 | Lemon Fish Rolls                 | A pleasant way to include fish
in
your family's diet.
(9 rows)
usa=# SELECT rr.id, rr.name, rr.description FROM recipe_recipes rr WHERE
rr.ftiidx ## 'st|a';
ERROR:  Your query contained only stopword(s), ignored
usa=# SELECT rr.id, rr.name, rr.description FROM recipe_recipes rr WHERE
rr.ftiidx ## 'st|ar';id | name | description
----+------+-------------
(0 rows)

I don't see how that's correct?  Those ERRORs seem to be valid syntax to
me...

Chris



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: Open 7.3 issues
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: tsearch bug in 7.2.1?