- PostgreSQL 11 Server Side Programming Quick Start Guide
- Luca Ferrari
- 163字
- 2021-06-10 19:23:03
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.
- 基于C語言的程序設(shè)計
- 微型計算機(jī)控制技術(shù)
- 完全掌握AutoCAD 2008中文版:綜合篇
- 深度學(xué)習(xí)與目標(biāo)檢測
- 工業(yè)機(jī)器人力覺視覺控制高級應(yīng)用
- Web璀璨:Silverlight應(yīng)用技術(shù)完全指南
- AVR單片機(jī)工程師是怎樣煉成的
- Hands-On DevOps
- Learning Cassandra for Administrators
- DynamoDB Applied Design Patterns
- EDA技術(shù)及其創(chuàng)新實踐(Verilog HDL版)
- Appcelerator Titanium Smartphone App Development Cookbook(Second Edition)
- 輸送技術(shù)、設(shè)備與工業(yè)應(yīng)用
- 百度智能小程序:AI賦能新機(jī)遇
- 歐姆龍CP1系列PLC原理與應(yīng)用