tsearch bug in 7.2.1?

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: tsearch bug in 7.2.1?
Date: 2002-08-15 05:43:01
Message-ID: GNELIHDDFBOCMGBFGEFOCELHCDAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-08-15 05:47:38 Re: tsearch bug in 7.2.1?
Previous Message Joe Conway 2002-08-15 05:36:31 Re: Open 7.3 issues