Full Text Search With PostgreSQL
5
votes
3
answers
2835
views
i have a table with this rows:
Stickers
------------------------------------------------------
ID | Title |Keywords (ts_vector)
------------------------------------------------------
01 | Sticker Case 580H |'580h':3 'cas':2 'stick':1
02 | Sticker Case 580L |'580l':3 'cas':2 'stick':1
03 | Sticker Case 580 |'580':3 'cas':2 'stick':1
04 | Sticker Case Plus 3000|'3000':4 'cas':2 'plus':3 'stick':1
Well, when i do search using this script, just row 03 return, how i do return the row 01 and 02?
SELECT
*
FROM
stickers
WHERE
keywords @@@ to_tsquery('case & 580');
Asked by Tommy
(63 rep)
Jan 25, 2013, 04:49 PM
Last activity: Aug 1, 2023, 05:17 PM
Last activity: Aug 1, 2023, 05:17 PM