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

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
主站蜘蛛池模板: 济南市| 札达县| 阳曲县| 璧山县| 宝鸡市| 湾仔区| 板桥市| 西贡区| 城口县| 启东市| 汝州市| 辽阳市| 沧源| 白朗县| 贺州市| 砀山县| 晋城| 合阳县| 陆川县| 芜湖县| 河西区| 崇州市| 福清市| 西乡县| 九龙县| 盘山县| 甘孜县| 噶尔县| 峨山| 栾城县| 固安县| 原阳县| 琼结县| 宁波市| 牙克石市| 临沂市| 赫章县| 外汇| 伊春市| 沙雅县| 东乌|