- PostgreSQL Server Programming(Second Edition)
- Usama Dar Hannu Krosing Jim Mlodgenski Kirk Roybal
- 248字
- 2021-07-23 20:36:49
Chapter 3. Your First PL/pgSQL Function
A function is the basic building block for extending PostgreSQL. A function accepts input in the form of parameters, and it can create output in the form of output parameters or return values. Many functions are provided by PostgreSQL itself, that is, common mathematical functions such as square roots and absolute values. For a comprehensive list of the functions that are already available, go to http://www.postgresql.org/docs/current/static/functions.html.
The functions that you create have the same privileges and ability that the built-in functions possess. The developers of PostgreSQL use the same libraries to extend the database that you use, as a developer, to write your business logic.
This means, that you have the tools available to be a first-class citizen of the PostgreSQL development community. In fact, there are no second-class seats on this bus.
A function accepts parameters that can be of any data type available in PostgreSQL, and it returns results to the caller using the same type. What you do within the function is entirely up to you. You have been empowered to do anything that PostgreSQL is capable of doing. You are herewith also warned that you are capable of doing anything that PostgreSQL is capable of doing. The training wheels are off.
In this chapter, you will learn the following topics:
- The basic building blocks of a PostgreSQL function
- Passing parameters into a function
- The basic control structures inside a function
- Returning results out of a function
- Practical Data Analysis Cookbook
- C語(yǔ)言程序設(shè)計(jì)實(shí)踐教程(第2版)
- HoloLens Beginner's Guide
- Linux核心技術(shù)從小白到大牛
- 深入淺出Spring Boot 2.x
- Java 11 Cookbook
- PhoneGap Mobile Application Development Cookbook
- 低代碼平臺(tái)開(kāi)發(fā)實(shí)踐:基于React
- FPGA嵌入式項(xiàng)目開(kāi)發(fā)實(shí)戰(zhàn)
- After Effects CC案例設(shè)計(jì)與經(jīng)典插件(視頻教學(xué)版)
- HTML5與CSS3權(quán)威指南
- 編程的原則:改善代碼質(zhì)量的101個(gè)方法
- Learning Behavior:driven Development with JavaScript
- Mastering Android NDK
- Real Time Analytics with SAP HANA