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

Summary

PostgreSQL provides advanced features that allow you to avoid writing a program to solve common problems when dealing with data structures and SQL statements. Thanks to the RETURNING predicate, it is possible for you to get back automatically generated data, such as an incremental key. Conflict resolution allows us to perform a kind of 'tuple merging' when dealing with INSERT and UPDATE statements against the same tuples, but one of its most powerful features is surely the Common Table Expression, which not only allows us to re-write complex queries by splitting them into more readable pieces, but also allows us to perform statement pipelining and recurse over a result set.

Knowing these features will allow you to interact with a PostgreSQL cluster efficiently and solve common problems in your day-to-day use quickly and easily.

In Chapter 3, The PL/pgSQL Language, we will look at how to implement complex constructs by means of the default procedural language built in in PostgreSQL: PL/pgSQL.

主站蜘蛛池模板: 治多县| 阿瓦提县| 北辰区| 密云县| 平阳县| 谷城县| 东源县| 额尔古纳市| 昌都县| 泊头市| 遂昌县| 宿迁市| 塔河县| 长葛市| 阜康市| 安顺市| 泽州县| 阿坝县| 遂川县| 吉木乃县| 响水县| 同德县| 炉霍县| 阳原县| 乌兰县| 嵊州市| 麻阳| 波密县| 金门县| 临夏县| 沙坪坝区| 洛隆县| 巨鹿县| 元氏县| 石屏县| 乡宁县| 祁门县| 武汉市| 静宁县| 南宫市| 涟水县|