How to work with Stored Procedures

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

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…


End of content

No more pages to load