A Stored Procedure is an user defined SQL code that contains a sequence of SQL instructions. A Stored Procedure can be thought of as a function in other programming languages. Stored Procedures are not part of standard SQL. But, multiple RDBMS providers provide the Stored Procedure functionality. What is it?…
Text Search With Trigrams in PostgreSQL - Part 2 In the previous blog post, we learned how to use trigrams for text searching and how they work behind the scenes in PostgreSQL. We also ran some queries and found the results. But that's not the end. Let's see how fast…
Text Search With Trigrams Hey folks, consider the situation you are writing a mail to your manager and you misspelled the word “cancel” as “cancer”. Then your text editor comes to the rescue and provides suggestions that you should type cancel instead of cancer. How does it find that spelling…
