- 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.
推薦閱讀
- Getting Started with Gulp(Second Edition)
- Building Modern Web Applications Using Angular
- 軟件項目管理(第2版)
- 數據結構和算法基礎(Java語言實現)
- Getting Started with ResearchKit
- Manga Studio Ex 5 Cookbook
- Learning RabbitMQ
- Apache Spark Graph Processing
- Java面向對象程序開發及實戰
- Learn React with TypeScript 3
- RabbitMQ Cookbook
- RSpec Essentials
- Mastering Akka
- Scratch趣味編程:陪孩子像搭積木一樣學編程
- Unity Android Game Development by Example Beginner's Guide