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.
Excellent ! Short, concise ... really clean explanation. Thanks
that's a really good explanation. Thank you for making this video.
Nice video
Thanks for sharing
great synopsis, thank you!
Great video! Thanks!
Great explanation, thanks!
Glad you enjoyed it!
Awesome video!!
Hi, whichi software are you typing sql at ? looks gorgeous
Great job man!! ❤
What's the SQL editor you're using?
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')
What coding IDE are you using?
Looks like rider with a theme.
Datagrip
Great intro!
super helpful thanks
Thank you man!
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
Спасибо за видео!
great video
Thank you!
what is the song from intro? 🔥