Sample Header Ad - 728x90

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