Rowsets are similar to arrays in many ways, but they mainly differ in their usage. For most data manipulations, you will want to use rowsets, as the SQL language is designed to deal with them. Arrays, however, are most useful for static storage. They are more complicated for client applications to use than rowsets, with usability features missing, such as no simple and straightforward built-in ways to iterate over them.
PostgreSQL Server Programming
PostgreSQL Server Programming
Overview of this book
Table of Contents (21 chapters)
PostgreSQL Server Programming Second Edition
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
What Is a PostgreSQL Server?
Server Programming Environments
Your First PL/pgSQL Function
Returning Structured Data
PL/pgSQL Trigger Functions
PostgreSQL Event Triggers
Debugging PL/pgSQL
Using Unrestricted Languages
Writing Advanced Functions in C
Scaling Your Database with PL/Proxy
PL/Perl – Perl Procedural Language
PL/Tcl – Tcl Procedural Language
Publishing Your Code as PostgreSQL Extensions
PostgreSQL as an Extensible RDBMS
Index
Customer Reviews