- 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.
推薦閱讀
- 黑客攻防從入門到精通（實戰秘笈版）
- 零起步玩轉掌控板與Mind+
- 實戰低代碼
- Swift 3 New Features
- 21天學通C++（第6版）
- Microsoft Dynamics GP 2013 Reporting, Second Edition
- Java軟件開發基礎
- 用戶體驗增長：數字化·智能化·綠色化
- Java EE 8 Application Development
- 數據結構案例教程（C/C++版）
- Visual Foxpro 9.0數據庫程序設計教程
- Learning Continuous Integration with TeamCity
- Learning AWS
- UI設計全書（全彩）
- Kotlin極簡教程