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

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.

主站蜘蛛池模板: 壤塘县| 商丘市| 宁蒗| 沂源县| 紫金县| 江西省| 长兴县| 三门峡市| 西和县| 石楼县| 公主岭市| 新兴县| 五寨县| 当雄县| 邵东县| 遵化市| 宝清县| 颍上县| 涟源市| 玉门市| 福安市| 林周县| 永和县| 盘锦市| 望城县| 琼海市| 麦盖提县| 梓潼县| 永济市| 肥乡县| 温泉县| 方正县| 临湘市| 曲麻莱县| 柘荣县| 化德县| 措勤县| 克拉玛依市| 个旧市| 白朗县| 西乌珠穆沁旗|