官术网_书友最值得收藏!

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
主站蜘蛛池模板: 阳西县| 汝州市| 民县| 苗栗市| 桃园市| 水富县| 西乌| 弥勒县| 兴安盟| 宁陕县| 许昌县| 万安县| 阿拉尔市| 云阳县| 宣恩县| 宁化县| 西丰县| 泽库县| 塔河县| 化州市| 北宁市| 潮安县| 遵化市| 滨海县| 柳河县| 依兰县| 雅安市| 蒲城县| 沧源| 淳安县| 武功县| 油尖旺区| 呼和浩特市| 容城县| 玉门市| 屏南县| 错那县| 宁蒗| 涟源市| 清水河县| 新乡县|