- PostgreSQL Server Programming（Second Edition）
- Usama Dar Hannu Krosing Jim Mlodgenski Kirk Roybal
- 155字
- 2021-07-23 20:36:50
Chapter 4. Returning Structured Data
In the previous chapter, we saw functions that return single values. These functions return either a "scalar," simple type such as an integer, text, or data; or a more complex type, similar to a row in the database table. In this chapter, we will expand these concepts and show you how to return your data to the client in more powerful ways.
We will also examine the following topics:
- Differences between SETOF scalars, rows, and arrays
- Returning CURSORs, which are kind of "lazy" tables, that is, something that can be used to get a set of rows, but which may not have actually evaluated or fetched the rows yet, as the modern world is not about rigid table-structured data
- Ways to deal with more complex data structures, both predefined and dynamically created
Let's start with a simple example and then add more features and variants as we go.
推薦閱讀
- 深度實踐OpenStack：基于Python的OpenStack組件開發
- Java 9 Concurrency Cookbook（Second Edition）
- JavaScript修煉之道
- JavaScript 從入門到項目實踐（超值版）
- 垃圾回收的算法與實現
- Learning AWS Lumberyard Game Development
- Visual C++串口通信技術詳解（第2版）
- Microsoft System Center Orchestrator 2012 R2 Essentials
- Python大學實用教程
- Android應用開發實戰
- C# 7.1 and .NET Core 2.0：Modern Cross-Platform Development（Third Edition）
- HTML5 Canvas核心技術：圖形、動畫與游戲開發
- Learning Gerrit Code Review
- Hands-On Exploratory Data Analysis with Python
- 軟件測試實用教程