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

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.

主站蜘蛛池模板: 茌平县| 澄江县| 寿阳县| 邯郸市| 福清市| 宁河县| 远安县| 称多县| 芦溪县| 景谷| 亳州市| 延庆县| 诏安县| 龙口市| 孟津县| 合江县| 罗江县| 宝清县| 常山县| 左贡县| 平和县| 南阳市| 余干县| 昆山市| 无棣县| 健康| 光山县| 许昌市| 巨鹿县| 滨州市| 山阴县| 晴隆县| 噶尔县| 南陵县| 会宁县| 阳新县| 稻城县| 额敏县| 乐都县| 富平县| 历史|