10:56 on my end, line 68 didn't seem to utilize the index on line 76. Because the index on line 76 is using to_tsvector('english', document), I had to match that as well in the WHERE clause in line 68. WHERE TO_TSVECTOR('english', document) @@ WEBSEARCH_TO_TSQUERY('thor')
You can join the tables and build ts_vector with columns from whatever tables you’d like to search on. Just like in the video when he references name or description, it could have been table1.name and table2.description if they were in two different tables that you joined.
![[#2024MAMA] ROSÉ (로제), Bruno Mars - APT. | Mnet 241122 방송](http://i.ytimg.com/vi/dgGqD28J6aQ/mqdefault.jpg)
Excellent ! Short, concise ... really clean explanation. Thanks
that's a really good explanation. Thank you for making this video.
Hi, whichi software are you typing sql at ? looks gorgeous
great synopsis, thank you!
Awesome video!!
10:56 on my end, line 68 didn't seem to utilize the index on line 76. Because the index on line 76 is using to_tsvector('english', document), I had to match that as well in the WHERE clause in line 68.
WHERE TO_TSVECTOR('english', document) @@ WEBSEARCH_TO_TSQUERY('thor')
Great video! Thanks!
Nice video
Thanks for sharing
Great explanation, thanks!
Glad you enjoyed it!
What if i want to join multiple tables and perform search on those columns
You can join the tables and build ts_vector with columns from whatever tables you’d like to search on. Just like in the video when he references name or description, it could have been table1.name and table2.description if they were in two different tables that you joined.
@@jeyfus thanks
What's the SQL editor you're using?
What coding IDE are you using?
Looks like rider with a theme.
Datagrip
Great job man!! ❤
Great intro!
Спасибо за видео!
super helpful thanks
what is the song from intro? 🔥
Thank you man!
great video
Thank you!