- PostgreSQL 11 Server Side Programming Quick Start Guide
- Luca Ferrari
- 205字
- 2021-06-10 19:23:02
Statement Tricks: UPSERTs, RETURNING, and CTEs
Before taking a closer look at server-side programming, it is worth exploring some of the cool features PostgreSQL provides that allow us to enhance statements. Sometimes, developers start working in a rush to solve a specific problem, which often means writing a function, a routine, or a whole program just to inspect some data. The features provided by PostgreSQL alleviate the need to do this.
This chapter will look at some of these features, and will offer hints and tricks so that you can gain as much as possible from ordinary statements. This will not only make any problems simpler to address, but will also improve your database experience.
In particular, in day-to-day database activity, there is often the need to get back auto-generate values (for example, keys, dates, timestamps, and so on), fix insertion conflicts, and even recursing on a flat data set.
So, after reading this chapter, we will have learned the following:
- How to solve tuple insertion conflicts
- How to get back automatically generated tuple data, such as incremental keys or timestamps
- How to write better statements with Common Table Expressions
- How to perform recursion at a statement level using Recursive Common Table Expressions
- Mastering Mesos
- Word 2000、Excel 2000、PowerPoint 2000上機指導與練習
- Photoshop CS4經典380例
- 手把手教你玩轉RPA:基于UiPath和Blue Prism
- AWS Administration Cookbook
- PyTorch Deep Learning Hands-On
- 嵌入式操作系統
- Mastering ServiceNow Scripting
- 新編計算機圖形學
- 智能生產線的重構方法
- 人工智能技術入門
- Visual Studio 2010 (C#) Windows數據庫項目開發
- Apache源代碼全景分析(第1卷):體系結構與核心模塊
- 青少年VEX IQ機器人實訓課程(初級)
- 智能制造系統及關鍵使能技術