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
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 |