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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
