What's new
Warez.Ge

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

Creating your own function in PostgreSQL database A Tutorial for Beginners

voska89

Moderator
Staff member
8230566a2676fb24d26a9520c9a06030.jpeg

Creating your own function in PostgreSQL database: A Tutorial for Beginners by Djoni Darmawikarta
English | 2022 | ISBN: N/A | ASIN: B0BKXDS1DG | 70 pages | EPUB | 1.35 Mb
A function does some computation and returns a value. We create a function because we need to use the function more than just once and likely in more than just in one program.​

In PostgreSQL database you can create your own function using its procedural language called PL/pgSQL.
While SQL always processes set of rows, PL/pgSQL can process row by row. PL/pgSQL also provides procedural language capabilities, such as if-then-else and looping.
Once your function is created, you can use it in the same way as you use the built-in functions.
When you finish reading this book and trying its examples, you would have equipped yourself with the skills to create functions with PL/pgSQL programs to participate in a real-world development project.


Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Links are Interchangeable - No Password - Single Extraction
 

Users who are viewing this thread

Back
Top